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

?

?

?