IBM å
(C) IBM Corp. 2000

Net Search Extender

°ü¸® ¹× »ç¿ëÀÚ ¾È³»¼­


SQL Å×ÀÌºí °ª ÁöÁ¤ ÇÔ¼ö¸¦ »ç¿ëÇÏ´Â ´Ü¼ø ¿¹

SQL Å×ÀÌºí °ª ÁöÁ¤ ÇÔ¼ö´Â ÀÌÀüÀÇ ¿¹¿¡¼­ ÀÛ¼ºµÈ ÅØ½ºÆ® À妽º¿¡¼­ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.

SQL Å×ÀÌºí °ª ÁöÁ¤ ÇÔ¼ö Äõ¸®´Â ÀÌÀü¿¡ »ç¿ëµÈ CONTAINS Äõ¸®¿¡ ÇØ´çµË´Ï´Ù. ÀÚ¼¼ÇÑ Á¤º¸´Â *** ÆäÀÌÁöÀÇ "ÅØ½ºÆ® À妽º µ¿±âÈ­"¸¦ ÂüÁ¶ÇϽʽÿÀ.

db2 "SELECT author, story FROM books b, table(db2ext.textsearch 
     ('\"cat\"','DB2EXT','MYTEXTINDEX', 0, 2, CAST 
     (NULL AS VARCHAR(18)))) T where T.primKey = b.isbn

ÀÚ¼¼ÇÑ »çÇ×Àº °Ë»ö¿¡ ´ëÇÑ SQL Å×ÀÌºí °ª ÁöÁ¤ ÇÔ¼ö »ç¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.

Âü°í

CAST(NULL AS VARCHAR(18))´Â Å×À̺í books¿¡ ´ëÇÑ ±âº» Ű¿¡ ÇØ´çµÇ´Â Å×ÀÌºí °ª ÁöÁ¤ ÇÔ¼ö¸¦ È£ÃâÇÕ´Ï´Ù.

°¢ ±âº» Ű À¯Çü¿¡´Â Å×ÀÌºí °ª ÁöÁ¤ ÇÔ¼ö°¡ ÀÖ½À´Ï´Ù. À̰ÍÀº DB2ÀÇ ¿Ã¹Ù¸¥ Å×ÀÌºí °ª ÁöÁ¤ ÇÔ¼ö¸¦ ½Äº°ÇÕ´Ï´Ù.


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