DB2 SEQUENCE 使用

DB2 SEQUENCE 使用

--创建序列

 DROP Sequence DWAPP.TEST;

CREATE Sequence DWAPP.TEST

    START WITH 1 increment BY 1 cache 20 minvalue 1 maxvalue 2147483647 no cycle no ORDER;

 

 

--测试 使用序列

SELECT NEXTVAL for DWAPP.TEST  FROM SYSIBM.SYSDUMMY1;

 

DROP TABLE DWAPP.TEST;

create table DWAPP.TEST(id varchar(30));

 

insert into DWAPP.TEST values( NEXTVAL FOR DWAPP.TEST );

SELECT * FROM DWAPP.TEST;