MVSFORUMS.com

[JOHNCWL]

Our clients are facing a problem due to the new version 7 of DB2.
So they requested to change a Db2 table column field which is used by the source (application). They are asking us to change a column name NAME to "NAME".

After generating the DCLGEN we checked the column name 'NAME'. This column name is not created with double quotes.

Whether the column names of the table which is used in the source should be used with double quotes.

or

Where should these column names be used with double quotes?


Thanks

[bauer]

Hi,

YEAR for example is an reserved word in DB2. If you have an table with a column YEAR you should code for example

INSERT INTO <tablename> "YEAR", FIELD1, FIELD2.... VALUES ('2004', '...........)

Use the double quote to specify the fields names in SELECT. UPDATE, INSERT .... statements.