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;