DB2 建立ID自增表

转载至：http://www.cfei.net/archives/214

CREATE  TABLE
T_RUNNING_THREAD
(
ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1 ),
NAME VARCHAR(150),
BEGINTIME VARCHAR(50),
ENDTIME VARCHAR(50),
DESC VARCHAR(4000),
SUCCESSFLAG CHARACTER(1),
PRIMARY KEY (ID)
)

加上GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1 )这句就行了
start with 1 ：就是从1开始
increment by 1 ：每次自增1