Documentation
(C) IBM Corp. 1996, 2000

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


ÅØ½ºÆ® Ž»ö

ÅØ½ºÆ®¸¦ Ž»öÇÏ´Â API ÇÔ¼ö·Î DesGetSearchResultTable ÇÔ¼ö°¡ ÀÖ½À´Ï´Ù.

Ž»ö °á°ú Å×À̺í È®º¸(DesGetSearchResultTable)

DesGetSearchResultTable ÇÔ¼ö´Â ƯÁ¤ÇÑ ÅØ½ºÆ® Ä÷³ÀÇ ÅØ½ºÆ® Ä÷³À» ÅëÇØ Ž»ö¿ë Ž»ö Àμö¸¦ ¼ö½ÅÇϰí Å×ÀÌºí¿¡ °á°ú¸¦ ÀúÀåÇÕ´Ï´Ù. °á°ú Å×ÀÌºí¿¡´Â ¹ß°ßµÈ °¢ ¹®¼­ÀÇ ÇÚµéÀÌ µé¾î ÀÖ½À´Ï´Ù. ¶ÇÇÑ ÁöÁ¤µÈ Ž»ö ¿É¼Ç¿¡ µû¶ó ¼øÀ§ Á¤º¸¿Í ÀÏÄ¡ °ªÀÇ ¼ö°¡ µé¾î ÀÖ½À´Ï´Ù.

¶ÇÇÑ RANK ¹× NO_OF_MATCHES ±â´ÉÀ» »ç¿ëÇÏ¿© ÀÌ Á¤º¸¸¦ ¾òÀ» ¼ö ÀÖ½À´Ï´Ù. ¾Æ·¡¿¡ ±× ¿¹°¡ ³ª¿Í ÀÖ½À´Ï´Ù.

     INSERT INTO RESULT
            SELECT COMMENTHANDLE,
                   RANK(COMMENTHANDLE, '"stored procedures"'),
                   NO_OF_MATCHES(COMMENTHANDLE, '"stored procedures"')
            FROM DB2TX.SAMPLE
            WHERE  CONTAINS(COMMENTHANDLE, '"stored procedures"') = 1

DesGetSearchResultTableÀº ±âº» Å×ÀÌºí¿¡¼­¸¸ »ç¿ëÇÒ ¼ö ÀÖÁö¸¸, Á¶È¸°¡ ÅØ½ºÆ® Àü¿ë Á¶È¸ÀÏ °æ¿ì DB2 Text Extender ±â´ÉÀ» »ç¿ëÇÏ´Â °Íº¸´Ù ºü¸¦ ¼ö ÀÖ½À´Ï´Ù. °ð¹Ù·Î DB2 Text Extender ¼­¹ö·Î °¡¼­ ¼øÀ§¿Í ÀÏÄ¡ Ƚ¼ö¸¦ °¡Á®¿À¸ç, ¹ß°ßÇÑ ÀÏÄ¡ ¹®¼­ÀÇ ¼ýÀÚ¸¸Å­¸¸ ·çÇÁ¸¦ µ½´Ï´Ù. ´Ù¸¥ ÇÑÆíÀ¸·Î UDF ¿¹¿¡¼­ CONTAINS ÇÔ¼ö´Â Å×À̺íÀÇ °¢ Çึ´Ù ÇÑ ¹ø¾¿ È£ÃâµË´Ï´Ù. ±×·± ´ÙÀ½, ±ÔÁ¤ Çึ´Ù RANK ¹× NO_OF_MATCHES ÇÔ¼ö°¡ È£ÃâµË´Ï´Ù. ¹ß°ßµÈ ¹®¼­¸¶´Ù, º°µµ Ž»öÀÌ ¼¼¹ø¾¿ ÀÌ·ç¾îÁý´Ï´Ù.

ÀÔ·Â

ÀÔ·Â ¸Å°³º¯¼ö´Â ´ÙÀ½°ú °°½À´Ï´Ù.

Ãâ·Â

¿­¶÷ ¿É¼ÇÀÌ ÁöÁ¤µÇ¸é, ÀÌ ÇÔ¼ö´Â Á¤º¸¸¦ ¿­¶÷Çϱâ À§ÇÑ Æ÷ÀÎÅ͸¦ ¸®ÅÏÇÕ´Ï´Ù.


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