SEARCH_RESULT ±â´ÉÀº Å×ÀÌºí °ª ±â´ÉÀÇ DB2 °³³äÀ» ÀÌ¿ëÇÕ´Ï´Ù. ±â´ÉÀº SQL¹®ÀÇ FROM Àý¿¡¼ »ç¿ëµÇ¸é, ÁöÁ¤µÈ Ž»ö ¹®ÀÚ¿ÀÇ Å½»ö °á°ú¸¦ °¡Áø Áß°£ Å×À̺íÀ» ¸®ÅÏÇÕ´Ï´Ù. Ž»ö ¹®ÀÚ¿ ±¸¹®Àº Ž»ö ÀμöÀÇ ±¸¹®¿¡ ¼³¸íµÈ °Í°ú °°½À´Ï´Ù. CONTAINS ¶Ç´Â RANK¿Í ºñ±³ÇÑ ÀÌ ±â´ÉÀÇ ÀÌÁ¡Àº Å« Å×À̺íÀÌ ÀÖÀ» °æ¿ì »ó´çÈ÷ ¼º´ÉÀÌ Çâ»óµÈ´Ù´Â Á¡ÀÔ´Ï´Ù.
¸®ÅϵǴ Å×À̺íÀº ´ÙÀ½°ú °°Àº ±¸Á¶ÀÔ´Ï´Ù.
Ä÷³ À̸§ µ¥ÀÌÅÍ À¯Çü HANDLE DB2TX.DB2TEXTH, DB2TX.DB2TEXTFH NUMBER_OF_MATCHES INTEGER RANK DOUBLE
¿¹:
db2=>SET CURRENT FUNCTION PATH = db2tx db2=>SELECT author FROM db2tx.sample T1, table(DB2TX.SEARCH_RESULT('DB2TX','SAMPLE','MYDOCHANDLE','"compress"')) T2
¿©±â¼ T1.handle = T2.mydochandle
ÇöÀç °æ·Î¸¦ ¼³Á¤ÇÏÁö ¾Ê¾ÒÀ¸¸é, ¿¹ÀÇ ÃÖÁ¾ ÇàÀº ¾Æ·¡¿Í °°½À´Ï´Ù.
¿©±â¼ cast(T1.handle as varchar(60)) = cast(T2.mydochandle as varchar (60))
SELECT NUMBER_OF_MATCHES,RANK,HANDLEÀº ¼¼ Ç׸ñ ¸ðµÎ°¡ ¸®Åϵǵµ·Ï ÇÏÁö¸¸, ¿øÇÏ´Â Á¶ÇÕÀ» ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù. ¿¹¸¦ µé¾î ¼øÀ§¿Í °ü·ÃµÈ ÁýÁßÀûÀΠ󸮸¦ ¹æÁöÇϱâ À§ÇØ, RANK¸¦ »ý·«ÇϰíÀÚ ÇÒ °ÍÀÔ´Ï´Ù.
HANDLE °ª¸¸ ÇÊ¿äÇÏ´Ù¸é, SELECT COUNT(*)¸¦ »ç¿ëÇÏ¸é µË´Ï´Ù.