CODEWITHSUNDEEP
db2sequenceauto-increment
Kapil Patel
Kapil Patel

Reputation: 11

Reason code = "1".. SQLCODE=-846, SQLSTATE=42815

create TABLE STUDENT_TEMP
(
    USER_ID VARCHAR(10) NOT NULL GENERATED ALWAYS AS IDENTITY 
             (START WITH 1 INCREMENT BY 1 MINVALUE 1 NO MAXVALUE NO CYCLE NO CACHE ORDER),
    USER_NAME VARCHAR(50) NOT NULL,
    CITY VARCHAR(20),
    PRIMARY KEY  (USER_ID)
 );

I want to insert auto increment column with sequence in db2. try to use this code from ibm site. but haven't got correct code yet.

Upvotes: 0

Views: 2291

Answers (1)

data_henrik
data_henrik

Reputation: 17118

Change the USER_ID to an integer or another numeric data type because VARCHAR is not a supported data type for identity columns.

create TABLE STUDENT_TEMP ( USER_ID int NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1 MINVALUE 1 NO MAXVALUE NO CYCLE NO CACHE ORDER), USER_NAME VARCHAR(50) NOT NULL, CITY VARCHAR(20), PRIMARY KEY (USER_ID) );

Upvotes: 2

Related Questions