Thanks Bruce, Jose and Edwards for answering my previous question on SQLID.

DB2 V7 on z/OS.

I have seen columns with " " in create table DDL as below.
Two columns are defined with double quotes while the other three without.
CREATE TABLE Q.OBJECT_DATA
(OWNER CHAR(8) FOR SBCS DATA NOT NULL ,
"NAME" VARCHAR(18) FOR SBCS DATA NOT NULL ,
"TYPE" CHAR(8) FOR SBCS DATA NOT NULL ,
SEQ SMALLINT NOT NULL ,
APPLDATA LONG VARCHAR FOR BIT DATA WITH DEFAULT NULL
)
IN DSQDBCTL.DSQTSCT3
AUDIT NONE
DATA CAPTURE NONE
CCSID EBCDIC;

Is the syntax right? DB2 Universal Database V8.1 certificate exam book doesn't show any sample of column names with double quote. But the DDLs one of DBAs used have columns with double quote. If the syntax is right what is the difference with and without double quotes?

Thanks,

James Park
Database Specialist II
Annapolis Data Center
410-260-7489
[Email address protected]




------------------------------------------------------------------------------
This email and any file transmitted with it may be confidential and are intended solely for the use of the individual or entity to whom they are addressed. If you received this email in error, please notify the Comptroller's System Manager by forwarding this message to [Email address protected]
==============================================================================



This footnote also confirms that this email message has been swept by the networkmaryland MIMEsweeper for the presence of computer viruses.

**********************************************************************


DB2 & UDB email list listserv db2-l LazyDBA home page