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;
?