ÀÀ¿ëÇÁ·Î±×·¥ °³¹ß ¾È³»¼­

±¸º° À¯Çü¿¡¼­ Å×À̺í Á¤ÀÇ

¿©·¯ °³ÀÇ ±¸º° À¯ÇüÀ» Á¤ÀÇÇÑ ÈÄ, À¯ÇüÀÌ ±¸º° À¯ÇüÀÎ Ä÷³À¸·Î Å×À̺íÀ» Á¤ÀÇÇÒ ¼ö ÀÖ½À´Ï´Ù. ´ÙÀ½Àº CREATE TABLE »ç¿ë ¿¹ÀÔ´Ï´Ù.

¿¹: ÆÇ¸Å

´Ù¸¥ ³ª¶ó¿¡¼­ÀÇ »ç¿ëÀÚ È¸»ç ÆÇ¸Å ÇöȲÀ» ±â·ÏÇϱâ À§ÇØ ´ÙÀ½°ú °°ÀÌ Å×À̺íÀ» Á¤ÀÇÇÑ´Ù°í °¡Á¤ÇϽʽÿÀ.

     CREATE TABLE US_SALES
       (PRODUCT_ITEM  INTEGER,
        MONTH         INTEGER CHECK (MONTH BETWEEN 1 AND 12),
        YEAR          INTEGER CHECK (YEAR > 1985),
        TOTAL         US_DOLLAR)
 
     CREATE TABLE CANADIAN_SALES
       (PRODUCT_ITEM  INTEGER,
        MONTH         INTEGER CHECK (MONTH BETWEEN 1 AND 12),
        YEAR          INTEGER CHECK (YEAR > 1985),
        TOTAL         CANADIAN_DOLLAR)
 
     CREATE TABLE GERMAN_SALES
       (PRODUCT_ITEM  INTEGER,
        MONTH         INTEGER CHECK (MONTH BETWEEN 1 AND 12),
        YEAR          INTEGER CHECK (YEAR > 1985),
        TOTAL         EURO)

À§ ¿¹¿¡¼­ ±¸º° À¯ÇüÀº ¿¹: ºñ¿ë¿¡¼­ µ¿ÀÏÇÑ CREATE DISTINCT TYPE¹®À» »ç¿ëÇÏ¿© ÀÛ¼ºµË´Ï´Ù. ÀÌ ¿¹¿¡¼­´Â Á¡°Ë Á¦ÇÑÁ¶°ÇÀ» »ç¿ëÇÕ´Ï´Ù. Á¡°Ë Á¦ÇÑÁ¶°Ç¿¡ ´ëÇÑ ¼¼ºÎ»çÇ×Àº SQL ÂüÁ¶¼­ÀÇ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.

¿¹: ÀÀ¿ëÇÁ·Î±×·¥ ¾ç½Ä

±¸Á÷ÀÚ°¡ ÀÛ¼ºÇÑ ¾ç½ÄÀ» ±â·ÏÇÏ´Â Å×À̺íÀ» ´ÙÀ½°ú °°ÀÌ Á¤ÀÇÇØ¾ß ÇÑ´Ù°í °¡Á¤ÇϽʽÿÀ.

     CREATE TABLE APPLICATIONS
       (ID                SYSIBM.INTEGER,
        NAME              VARCHAR (30),
        APPLICATION_DATE  SYSIBM.DATE,
        FORM              PERSONAL.APPLICATION_FORM)

±ÔÁ¤ÀÚ°¡ »ç¿ëÀÚÀÇ ±ÇÇÑ ºÎ¿© ID¿Í °°Áö ¾Ê°í ±âº» ÇÔ¼ö °æ·Î¸¦ º¯°æÇÏÁö ¾Ê¾ÒÀ¸¹Ç·Î ±¸º° À¯Çü À̸§À» ¿ÏÀüÈ÷ ±ÔÁ¤Çß½À´Ï´Ù. À¯Çü ¹× ÇÔ¼ö À̸§ÀÌ ¿ÏÀü ±ÔÁ¤µÇÁö ¾ÊÀ» ¶§¸¶´Ù DB2´Â ÇöÀç ÇÔ¼ö °æ·Î¿¡ ³ª¿­µÈ ½ºÅ°¸¶¸¦ °Ë»öÇϰí, ±ÔÁ¤µÇÁö ¾ÊÀº ÇöÀç À̸§°ú ÀÏÄ¡ÇÏ´Â ÇÔ¼ö À̸§ ¶Ç´Â À¯ÇüÀ» °Ë»öÇÕ´Ï´Ù. ÇöÀç ÇÔ¼ö °æ·Î¿¡¼­ (»ý·«µÈ °æ¿ì) SYSIBMÀÌ Ç×»ó °í·ÁµÇ¹Ç·Î ³»Àå µ¥ÀÌÅÍ À¯ÇüÀÇ ±ÔÁ¤À» »ý·«ÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿¹¸¦ µé¾î, SET CURRENT FUNCTION PATH = cherylÀ» ½ÇÇàÇÒ ¼ö ÀÖ°í, ÇöÀç ÇÔ¼ö °æ·Î Ư¼ö ·¹Áö½ºÅÍ °ªÀº "CHERYL"ÀÌ µÇ°í, "SYSIBM"ÀÌ Æ÷ÇÔµÇÁö ¾Ê½À´Ï´Ù. ÀÌÁ¦, CHERYL.INTEGER À¯ÇüÀÌ Á¤ÀǵÇÁö ¾Ê¾Ò´Ù¸é, CREATE TABLE FOO(COL1 INTEGER)¹®Àº SYSIBMÀÌ Ç×»ó SYSIBM.INTEGER À¯ÇüÀÇ COL1·Î¼­ °í·ÁµÇ¹Ç·Î ¿©ÀüÈ÷ ¼º°øÇÕ´Ï´Ù.

±×·¯³ª, ¿øÇÒ °æ¿ì ³»Àå µ¥ÀÌÅÍ À¯ÇüÀ» ¿ÏÀüÈ÷ ±ÔÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù. ÇöÀç ÇÔ¼ö °æ·Î »ç¿ë¿¡ ´ëÇÑ ¼¼ºÎ»çÇ×Àº SQL ÂüÁ¶¼­¿¡ ÀÖ½À´Ï´Ù.


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]