ÅØ½ºÆ®¸¦ Ž»öÇÏ´Â API ÇÔ¼ö·Î 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 ÇÔ¼ö°¡ È£ÃâµË´Ï´Ù. ¹ß°ßµÈ ¹®¼¸¶´Ù, º°µµ Ž»öÀÌ ¼¼¹ø¾¿ ÀÌ·ç¾îÁý´Ï´Ù.
ÀÔ·Â ¸Å°³º¯¼ö´Â ´ÙÀ½°ú °°½À´Ï´Ù.
¿¶÷ ¿É¼ÇÀÌ ÁöÁ¤µÇ¸é, ÀÌ ÇÔ¼ö´Â Á¤º¸¸¦ ¿¶÷Çϱâ À§ÇÑ Æ÷ÀÎÅ͸¦ ¸®ÅÏÇÕ´Ï´Ù.