2009.02.08 / 15:16
[DB2] ½ÃÄö½º »ý¼º, Á¶
¸ðÆ®
Ãßõ ¼ö 330
[DB2] ½ÃÄö½º »ý¼º,
Á¶È¸ DB
2006/10/26 14:39 |
* ½ÃÄö½º »ý¼º.
CREATE SEQUENCE SEQUENCE_NAME
AS
INTEGER
START WITH 1 //½ÃÀÛ ¹øÈ£(¼±ÅÃ)
INCREMENT BY 100
//Áõ°¡ºÐ(¼±ÅÃ)
CACHE 20
MINVALUE 1 //ÃÖ¼Ò°ª(¼±ÅÃ)
MAXVALUE 100000 //ÃÖ´ë°ª(¼±ÅÃ)
ORDER;
SEQUENCE_NAME ½ÃÄö½º À̸§
* ½ÃÄö½º Á¶È¸.
SELECT (NEXTVAL FOR SEQUENCE_NAME) AS SEQUENCE
FROM SYSIBM.SYSDUMMY1
NEXTVAL ½ÃÄö½ºÀÇ ´ÙÀ½ °ª
SEQUENCE_NAME ½ÃÄö½º À̸§
SEQUENCE º°¸í(Alias)
SYSIBM.SYSDUMMY1 Àӽà Å×À̺í(Dummy Table)
»¡°£»öÀ¸·Î Ç¥½ÃÇÑ ±ÛÀÚ ºÎºÐÀ» ¼öÁ¤ÇÏ¸é µÈ´Ù.