DB2数据库相关操作

自增字段的创建

create SEQUENCE ftpapp.LINKAGE_SEQ AS INTEGER MINVALUE 1 MAXVALUE 2147483647     START WITH 1 INCREMENT BY 1      CACHE 20 NO CYCLE NO ORDER;  --设置自增序列从20001开始ALTER SEQUENCE LINKAGE_SEQ RESTART WITH 20001;

使用自增字段 插入一条数据

INSERT INTO LINKAGE VALUES (NEXT VALUE FOR LINKAGE_SEQ,current date,'account1','sub1','0');

修改列类型

ALTER TABLE db2admin.ftp_adjust_definition ALTER COLUMN start_date  SET DATA TYPE timestamp;ALTER TABLE db2admin.ftp_adjust_definition ALTER COLUMN update_date SET DATA TYPE timestamp;

年月日 时分秒的显示

to_char(far.start_date,'yyyy-MM-dd hh24:mi:ss'),

timestamp类型 的数据是 current timestamp

CREATE TABLE db2admin.aaaaa (  start_date  timestamp,  update_date  timestamp  ) ;select * from AAAAA;insert into AAAAA values(current timestamp,current timestamp);(select current timestamp from SYSIBM.SYSDUMMY1)

查询表及列名及备注

select * from SYSIBM.SYSCOLUMNS;