Db2 Table Editor troubleshooting

Double quotes around column and field names in Db2 Table Editor forms

Symptom

When designing a form using the Db2 Table Editor application tools, certain field labels or column names might contain double-quotes, while others might not.

Cause

The presence of double-quotes in a column or field indicates that the column or field has the same name as a Db2® reserved word or keyword. Double quotes are applied to column names that are the same as Db2 reserved words or keywords by Db2 Table Editor.

Action

Double-quotes are used as a visual indicator by the Db2 Table Editor application to show that these labels or columns are named the same name as a Db2 Reserved Word. The Db2 database allows any such keywords to be used as ordinary identifiers, except in a context where they could also be interpreted as SQL keywords. In such cases, the word must be specified as a delimited identifier, with double-quotes used as the delimiter. Db2 Table Editor automatically supplies these delimiters within the wizards and screens used to build forms, and in the SQL and other code it generates when communicating with the Db2 database server.

For a list of Db2 Reserved words or keywords, refer to the Db2 Information Center.