Hello !
I'm new to DB2 systems and I don't really understand the IDENTITY clause in
the create table.
Why this command returns me this error ?
CREATE TABLE ArcoDB2.RTSCRIPT_QUE (
QUE_ID integer IDENTITY (1, 1) NOT NULL ,
QUE_DATA varchar(2000) NOT NULL
)
;
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "IDENTITY" was found following "QUE ( QUE_ID
integer". Expected tokens may include: "DEFAULT". SQLSTATE=42601
Besides, this command work well :
CREATE TABLE ArcoDB2.ARCOINFO (
FT_CID integer generated always as IDENTITY (start with 1, increment by 1)
NOT NULL ,
APPLICATION varchar (50) ,
CUSTOMVERSION varchar (50) ,
CATEGORY varchar (50) ,
PARMNAME varchar (50) ,
PARMVALUE varchar (200)
)
;
Thanks for help !
Dominic