DB2创建主键自增，时间自动获取的表

CREATE  TABLE ADMINISTRATOR.qbsource1
(
ID INTEGER NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1 ) ,
NAME VARCHAR(150),
TIME1 TIMESTAMP  WITH DEFAULT CURRENT TIMESTAMP

)

CREATE  TABLE ADMINISTRATOR.bjsource2
(
ID INTEGER NOT NULL PRIMARY KEY GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1 ) ,
NAME VARCHAR(150),
TIME1 TIMESTAMP  WITH DEFAULT CURRENT TIMESTAMP,
FLAG INTEGER WITH DEFAULT 0
)

CREATE  TABLE ADMINISTRATOR.cftarget2
(
ID INTEGER NOT NULL PRIMARY KEY ,
NAME VARCHAR(150),
TIME1 TIMESTAMP,
TIME TIMESTAMP  WITH DEFAULT CURRENT TIMESTAMP
)