IBM Books

Image, Audio, Video Extender °ü¸® ¹× ÇÁ·Î±×·¡¹Ö

QbScoreFromStr


Image Audio Video
X    

À̹ÌÁö Ư¼ºÀÌ Á¶È¸ ¹®ÀÚ¿­ÀÇ ±×°Í¿¡ ´ëÇÑ À¯»ç Á¤µµ¸¦ Ç¥ÇöÇÏ´Â ¼ýÀÚÀÎ À̹ÌÁö ½ºÄھ ¸®ÅÏÇÕ´Ï´Ù. À̹ÌÁö ÇÚµéÀÌ ¼ÓÇÑ Ä÷³°ú ¿¬°üµÈ QBIC īŻ·Î±×´Â À̹ÌÁöÀÇ ½ºÄھ °è»êÇÏ´Â µ¥ »ç¿ëµË´Ï´Ù. ½ºÄھ ³·À»¼ö·Ï À̹ÌÁöÀÇ Æ¯¼ºÀº Á¶È¸ ¹®ÀÚ¿­ÀÇ Æ¯¼º°ú ´õ¿í ÀÏÄ¡ÇÕ´Ï´Ù.

Include ÆÄÀÏ

¾øÀ½

±¸¹®

>>-QbScoreFromStr--(--imgHandle--,--query--)-------------------><
 

±¸¹®

°ÅºÎµÈ ¹öÀü

>>-QbScoreFromStr--(--query--,--imgHandle--)-------------------><
 

¸Å°³º¯¼ö(µ¥ÀÌÅÍ À¯Çü)

imgHandle(DB2Image)
À̹ÌÁö ÇÚµé.

query(VARCHAR(1024))
Á¶È¸ ¹®ÀÚ¿­.

¸®ÅÏ °ª(µ¥ÀÌÅÍ À¯Çü)

À̹ÌÁö ½ºÄÚ¾î(DOUBLE). ½ºÄÚ¾îÀÇ ¹üÀ§´Â 0.0¿¡¼­ºÎÅÍ ¹«ÇÑ¿¡ °¡±î¿î ¸Å¿ì Å« ¼ö¿¡ ´ÞÇÒ ¼ö ÀÖ½À´Ï´Ù. ½ºÄھ ³·À»¼ö·Ï ¸ñÇ¥ À̹ÌÁöÀÇ Æ¯¼º°ªÀº Á¶È¸¿¡ ÁöÁ¤µÈ Ư¼º°ª°ú ´õ¿í ÀÏÄ¡ÇÕ´Ï´Ù. ½ºÄÚ¾î 0.0Àº À̹ÌÁö°¡ Á¤È®È÷ ÀÏÄ¡ÇÔÀ» ÀǹÌÇÕ´Ï´Ù. ³Î(Null) °ª ½ºÄÚ¾î´Â À̹ÌÁö°¡ īŻ·Î±×È­µÇÁö ¾Ê¾ÒÀ½À» ÀǹÌÇÕ´Ï´Ù. ÀÌ UDFÀÇ °ÅºÎµÈ ¹öÀüÀº À̹ÌÁö°¡ īŻ·Î±×È­µÇÁö ¾Ê¾ÒÀ» ¶§ ½ºÄÚ¾î -1À» ¸®ÅÏÇÕ´Ï´Ù.

¿¹

Æò±Õ »ö»óÀÌ »¡°­»ö°ú ¾ÆÁÖ À¯»çÇÑ Å×À̺í Ä÷³¿¡ īŻ·Î±×È­µÈ À̹ÌÁö¸¦ ãÀ¸½Ê½Ã¿À.

SELECT name
FROM fabric
WHERE (QbScoreFromStr(Swatch_Img,
       'QbColorFeatureClass color=<255, 0, 0>'))<0.1


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