keywork column problem

iskapalli · Post by **iskapalli** » Fri Dec 16, 2011 4:23 am

Hi ,

We are useing TYPE keyword column as column name in terdata.It is getting below errror.

Syntax error, expected something like a name or a Unicode delimited identifier between ',' and the 'TYPE' keyword. SQL statement: USING (SEQUENCE SMALLINT, TYPE SMALLINT, VERSION SMALLINT, DATALEN INTEGER, SRC_SYS_ID VARCHAR(1

Please help me out

chulett · Post by **chulett** » Fri Dec 16, 2011 8:11 am

Seems to be a reserved word, can you rename the column to something like XXXX_TYPE?