Db2 “NEXTVAL” 函数在序列中检索下一个值

语法：SELECT NEXTVAL FOR twble FROM SYSIBM.SYSDUMMY1;

在使用之前应先创建序列： CREATE SEQUENCE your_sequence_name START WITH 1 INCREMENT BY 1 NO MAXVALUE NO CYCLE CACHE 10;

查看已有序列： SELECT * FROM SYSIBM.SYSSEQUENCES WHERE SEQUENCENAME = 'your_sequence_name';