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;
?
?
?
发布时间: 2012-09-29 10:30:01 作者: rapoo
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;
?
?
?