Ž»ö Àμö°¡ ³Ê¹« ¸¹Àº ¹ß»ýÀ» ãÀº °æ¿ì, Ãʱâ Ž»ö Àμö¿Í µÎ ¹øÂ° ºÎ¿ï-AND °ü°è¸¦ °áÇÕÇÑ Å½»öÀ», ¹üÀ§¸¦ Á¼È÷°Å³ª ¼¼ºÐÈÇÏ´Â µ¥ ÀÚÁÖ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
REFINE ÇÔ¼ö¸¦ »ç¿ëÇÏÁö ¾Ê°í Å×ÀÌºí¿¡ °á°ú¸¦ ÀúÀåÇϸç ÀÌ Å×ÀÌºí¿¡ ´ëÇÑ ´ÙÀ½ Ž»öÀ» Çϸé, Ž»ö °á°ú¸¦ ¼¼ºÐÈÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±ÔÁ¤ ¿ë¾î ¼ö¿¡ µû¶ó ÀÌ ¹æ½ÄÀº ¸¶Áö¸· Ž»ö Àμö¸¦ ÀúÀåÇϰí REFINEÀ» »ç¿ëÇÏ´Â ¹æ½Äº¸´Ù ´ú È¿À²ÀûÀÔ´Ï´Ù.
´ÙÀ½ ´Ü°è´Â Ž»öÇÏ¿© REFINE ÇÔ¼ö¸¦ »ç¿ëÇÑ ¼¼ºÐÈ ¹æ¹ýÀ» ³ªÅ¸³À´Ï´Ù. REFINE ÇÔ¼ö´Â µÎ ÀÔ·Â ¸Å°³º¯¼ö¸¦ °¡Áø ºÎ¿ï-AND °áÇÕÀΠŽ»ö Àμö¸¦ ¸®ÅÏÇÕ´Ï´Ù. REFINEÀÌ ¸®ÅÏÇÑ °áÇÕµÈ Å½»ö Àμö´Â À¯Çü LONG VARCHARÀÇ °ªÀÔ´Ï´Ù.
ÀÌ¹Ì ¼öÇàµÈ Ž»öÀÇ Å½»ö Àμö¸¦ º¸À¯ÇÏ´Â PREVIOUS_SEARCHES Å×À̺íÀ» ÀÛ¼ºÇϽʽÿÀ.
db2=>CREATE TABLE PREVIOUS_SEARCHES (step INT, searchargument LONG VARCHAR)
![]() |
»ùÇà Å×ÀÌºí¿¡¼ ´Ü¾î "compress"¸¦ Ž»öÇϽʽÿÀ.
db2=>SELECT COMMENT FROM DB2TX.SAMPLE WHERE DB2TX.CONTAINS (COMMENTHANDLE, '"compress"') = 1
ÀÌÈÄÀÇ ´Ü°è¿¡¼ »ç¿ëÇÒ Å½»ö Àμö¸¦ PREVIOUS_SEARCHES Å×ÀÌºí¿¡ »ðÀÔÇϽʽÿÀ.
db2=>INSERT INTO PREVIOUS_SEARCHES VALUES (1, '"compress"')
![]() |
Ž»öÀÌ ³Ê¹« ¸¹Àº ÅØ½ºÆ® ¹®¼¸¦ ¸®ÅÏÇÑ´Ù°í »ý°¢ÇÏ´Â °æ¿ì, 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
![]() |
¹ß°ßµÇ´Â ÅØ½ºÆ® ¹®¼ ¼ö°¡ ÃæºÐÈ÷ ÀÛ¾ÆÁú ¶§±îÁö ÀÌ ´Ü°è¸¦ ¹Ýº¹ÇÒ ¼ö ÀÖ½À´Ï´Ù.