DSXchange

Hi,

I am having problem while importing a DB2 DCLGEN in MetaStage.
Occurs that MetaStage not allow to set a collumn name like "TIMESTAMP"

ERROR: Erro 1 (line 13): 'TIMESTAMP' Column name cannot be SQL reserved word.

In IBM DB2 there is no restriction about a column name like TIMESTAMP.

Is there any fix about it?


Thanks in advanced.

Cassiano

In most databases use of reserved words is prohibited. DataStage tries to conform to SQL CAE Access Group standards, where use of reserved words is likewise prohibited. There are two possibilities.

One is to use quoted identifiers - to enclose the column names in double quote characters.

The other is to use only legal column names.