db2 序列

使用序列

insert into test(id) values (next value for seq_001);
select next value for EMMETHOD_SEQUENCE  FROM SYSIBM.SYSDUMMY1;
select previous value for EMMETHOD_SEQUENCE  FROM SYSIBM.SYSDUMMY1;
select s_assets.nextval FROM dual;

创建序列

create sequence seq_name
start with 1
increment by 1
no maxvalue 
no cycle;

修改序列

alter sequence EMMETHOD_SEQUENCE restart with 113750746;