Documentation
(C) IBM Corp. 1996, 2000

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


Ž»ö ¼º´É Çâ»ó

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(*)¸¦ »ç¿ëÇÏ¸é µË´Ï´Ù.


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