IBM Books

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

QbScoreFromName


Image Audio Video
X    

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

ÁÖ:

  1. EEE Àü¿ë: QbScoreFromNameÀº ÆÄƼ¼ÇµÈ µ¥ÀÌÅͺ£À̽º ȯ°æ¿¡¼­ Áö¿øµÇÁö ¾Ê½À´Ï´Ù. QbQueryGetString API¸¦ »ç¿ëÇÏ¿© Á¶È¸ ¹®ÀÚ¿­À» È®º¸ÇÑ ÈÄ¿¡ ´ë½Å QbScoreFromStr UDF¸¦ »ç¿ëÇϽʽÿÀ.

  2. QbScoreFromNameÀº ÆÄƼ¼ÇµÇÁö ¾ÊÀº µ¥ÀÌÅͺ£À̽º ȯ°æÀÇ °æ¿ì, ³ªÁß ¸±¸®½º¿¡¼­ °ÅºÎµÉ °ÍÀÔ´Ï´Ù. Á¶È¸¸¦ ´Ù½Ã »ç¿ëÇÏ·Á¸é, QbQueryGetString API¸¦ »ç¿ëÇÏ¿© Á¶È¸ ¹®ÀÚ¿­À» È®º¸Çϰí ÀÀ¿ëÇÁ·Î±×·¥¿¡¼­ ³ªÁß¿¡ »ç¿ëÇϱâ À§ÇØ ±× ¹®ÀÚ¿­À» ÀúÀåÇØ¾ß ÇÕ´Ï´Ù.

Include ÆÄÀÏ

¾øÀ½

±¸¹®

>>-QbScoreFromName--(--imgHandle--,--queryName--)--------------><
 

±¸¹®

°ÅºÎµÈ ¹öÀü

>>-QbScoreFromName--(--queryName--,--imgHandle--)--------------><
 

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

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

queryName(varchar(18))
Á¶È¸ ¿ÀºêÁ§Æ® À̸§.

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

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

¿¹

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

EXEC SQL BEGIN DECLARE SECTION;
char Img_fnd[100];
EXEC SQL END DECLARE SECTION;
 
EXEC SQL SELECT NAME
  INTO :Img_fnd
  FROM FABRIC
  WHERE (QBSCOREFROMNAME(SWATCH_IMG,
         'fshavgcol'))<0.1;


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