DB2 SQL：sequence

--sequence

create sequence <sequence>

start with <start_value>

increment by <step>

maxvalue <max>

no cycle

no cache;

 

drop sequence <sequence>;

 

alter sequence <sequence>

increment by <step>

maxvalue <max>

no cycle

no cache;

 

举例:

db2 -tv "create sequence seq_zzh01 start with 100 increment by 1 maxvalue 105 no cycle no cache"

db2 -tv "select seq_zzh01.nextval from sysibm.dual"

db2 -tv "alter sequence seq_zzh01 cycle cache 6 "

 

select nextval for <schema>.<sequence> from sysibm.sysdummy1;