DB2中创办SEQUENCE

DB2中创建SEQUENCE

创建SEQUENCE：

CREATE SEQUENCE NAME_XXX_SEQ  AS INT START WITH 1000 INCREMENT BY 1 MINVALUE 1        NO MAXVALUE NO CYCLE NO CACHE ORDER;

?查询SEQUENCE：

SELECT NEXTVAL FOR NAME_XXX_SEQ FROM SYSIBM.SYSDUMMY1;

?

?

?