TIMESTAMP - SQL reserved word

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
cassi_bsb
Participant
Posts: 11
Joined: Thu Oct 25, 2007 12:33 pm

TIMESTAMP - SQL reserved word

Post by cassi_bsb »

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

Image
Cassiano Fontoura
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”