Documentation
(C) IBM Corp. 1996, 2000

DB2 Text Extender
°ü¸® ¹× ÇÁ·Î±×·¡¹Ö


ÀÌÀü Ž»ö ¼¼ºÐÈ­

Ž»ö Àμö°¡ ³Ê¹« ¸¹Àº ¹ß»ýÀ» ãÀº °æ¿ì, Ãʱâ Ž»ö Àμö¿Í µÎ ¹øÂ° ºÎ¿ï-AND °ü°è¸¦ °áÇÕÇÑ Å½»öÀ», ¹üÀ§¸¦ Á¼È÷°Å³ª ¼¼ºÐÈ­ÇÏ´Â µ¥ ÀÚÁÖ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.

REFINE ÇÔ¼ö¸¦ »ç¿ëÇÏÁö ¾Ê°í Å×ÀÌºí¿¡ °á°ú¸¦ ÀúÀåÇϸç ÀÌ Å×ÀÌºí¿¡ ´ëÇÑ ´ÙÀ½ Ž»öÀ» Çϸé, Ž»ö °á°ú¸¦ ¼¼ºÐÈ­ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±ÔÁ¤ ¿ë¾î ¼ö¿¡ µû¶ó ÀÌ ¹æ½ÄÀº ¸¶Áö¸· Ž»ö Àμö¸¦ ÀúÀåÇϰí REFINEÀ» »ç¿ëÇÏ´Â ¹æ½Äº¸´Ù ´ú È¿À²ÀûÀÔ´Ï´Ù.

´ÙÀ½ ´Ü°è´Â Ž»öÇÏ¿© REFINE ÇÔ¼ö¸¦ »ç¿ëÇÑ ¼¼ºÐÈ­ ¹æ¹ýÀ» ³ªÅ¸³À´Ï´Ù. REFINE ÇÔ¼ö´Â µÎ ÀÔ·Â ¸Å°³º¯¼ö¸¦ °¡Áø ºÎ¿ï-AND °áÇÕÀΠŽ»ö Àμö¸¦ ¸®ÅÏÇÕ´Ï´Ù. REFINEÀÌ ¸®ÅÏÇÑ °áÇÕµÈ Å½»ö Àμö´Â À¯Çü LONG VARCHARÀÇ °ªÀÔ´Ï´Ù.

  1. ±âÁ¸ÀÇ Å½»ö Àμö¿ëÀ¸·Î Å×À̺íÀ» ÀÛ¼ºÇϽʽÿÀ.

    ÀÌ¹Ì ¼öÇàµÈ Ž»öÀÇ Å½»ö Àμö¸¦ º¸À¯ÇÏ´Â PREVIOUS_SEARCHES Å×À̺íÀ» ÀÛ¼ºÇϽʽÿÀ.

    db2=>CREATE TABLE PREVIOUS_SEARCHES (step INT,
                                         searchargument LONG VARCHAR)
    




    REQTEXT

  2. ù¹øÂ° Ž»ö Àμö¸¦ Ž»öÇϽʽÿÀ.

    »ùÇà Å×ÀÌºí¿¡¼­ ´Ü¾î "compress"¸¦ Ž»öÇϽʽÿÀ.

    db2=>SELECT COMMENT
                FROM DB2TX.SAMPLE
           WHERE DB2TX.CONTAINS (COMMENTHANDLE, '"compress"') = 1
    

    ÀÌÈÄÀÇ ´Ü°è¿¡¼­ »ç¿ëÇÒ Å½»ö Àμö¸¦ PREVIOUS_SEARCHES Å×ÀÌºí¿¡ »ðÀÔÇϽʽÿÀ.

    db2=>INSERT INTO PREVIOUS_SEARCHES
           VALUES (1, '"compress"')
    




    REQTEXT

  3. Ž»öÀ» ¼¼ºÐÈ­ÇϽʽÿÀ.

    Ž»öÀÌ ³Ê¹« ¸¹Àº ÅØ½ºÆ® ¹®¼­¸¦ ¸®ÅÏÇÑ´Ù°í »ý°¢ÇÏ´Â °æ¿ì, REFINE ÇÔ¼ö¸¦ »ç¿ëÇÏ¿© ÀÌÀüÀÇ Å½»ö ¿ë¾î¿Í ´Ü¾î "compiler"¸¦ °áÇÕÇÏ¿© Ž»öÀ» ¼¼ºÐÈ­ÇϽʽÿÀ.

    db2=>WITH LAST_STEP(STEP_MAX)
                AS (SELECT MAX(STEP)
                  FROM PREVIOUS_SEARCHES),
              LAST_SEARCH(LAST_SEARCH)
              AS (SELECT SEARCHARGUMENT
                  FROM PREVIOUS_SEARCHES,LAST_STEP
                  WHERE STEP = STEP_MAX)
         SELECT COMMENT
              FROM DB2TX.SAMPLE, LAST_SEARCH
              WHERE DB2TX.CONTAINS(COMMENTHANDLE,
                          DB2TX.REFINE(LAST_SEARCH, '"compiler"')) = 1
    

    ÀÌÈÄÀÇ ´Ü°è¿¡¼­ »ç¿ëÇÒ ¼¼ºÐÈ­µÈ Ž»ö Àμö¸¦ PREVIOUS_SEARCHES Å×ÀÌºí¿¡ »ðÀÔÇϽʽÿÀ.

    db2=>INSERT INTO PREVIOUS_SEARCHES
           WITH LAST_STEP(STEP_MAX)
                AS (SELECT MAX(STEP)
                    FROM PREVIOUS_SEARCHES)
           SELECT STEP_MAX+1, DB2TX.REFINE(SEARCHARGUMENT, '"compiler"')
             FROM PREVIOUS_SEARCHES, LAST_STEP
    




    REQTEXT

    ¹ß°ßµÇ´Â ÅØ½ºÆ® ¹®¼­ ¼ö°¡ ÃæºÐÈ÷ ÀÛ¾ÆÁú ¶§±îÁö ÀÌ ´Ü°è¸¦ ¹Ýº¹ÇÒ ¼ö ÀÖ½À´Ï´Ù.


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