创建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;
创建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;