DB2 Sequence基本操作

1、创建sequences
CREATE SEQUENCE TEST_SEQ
       AS bigint
       START WITH 1
       INCREMENT BY 1
       NO MAXVALUE
       CYCLE
       CACHE 20;
       
2、删除sequence

DROP SEQUENCE  DB2ADMIN.TEST_SEQ restrict

3、查询sequence
select * from sysibm.SYSSEQUENCES where seqname = 'TEST_SEQ' and seqschema = 'DB2ADMIN'

4、获取下一个sequence
values nextval for TEST_SEQ