IBM Books

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

ÁÖ¼® °Ë»ö

À̹ÌÁö, ¿Àµð¿À ¶Ç´Â ºñµð¿À ¿ÀºêÁ§Æ®·Î ÀúÀåµÈ ÁÖ¼®À» °Ë»öÇÏ·Á¸é, Comment UDF¸¦ »ç¿ëÇϽʽÿÀ. ¿ÀºêÁ§Æ®¿¡ ´ëÇÑ ÁÖ¼® °Ë»ö½Ã, ¿ÀºêÁ§Æ® ÇÚµéÀÌ ÀÖ´Â µ¥ÀÌÅͺ£À̽º Å×ÀÌºí¿¡¼­ Ä÷³À» ÁöÁ¤ÇÕ´Ï´Ù. ¿¹¸¦ µé¾î, ´ÙÀ½ÀÇ ¸í·É¹®Àº Á÷¿ø Å×ÀÌºí¿¡ ¿Àµð¿À Ŭ¸³À» »ç¿ëÇÏ¿© ÀúÀåµÈ ÁÖ¼®À» °Ë»öÇÕ´Ï´Ù.

EXEC SQL BEGIN DECLARE SECTION;
struct {
       short len;
       char data[32700];
       }hvComment
EXEC SQL END DECLARE SECTION;
 
EXEC SQL SELECT COMMENT(SOUND)
     INTO :hvComment
     FROM EMPLOYEE
     WHERE NAME = 'Anita Jones';

Comment UDF¸¦ SQL Á¶È¸ÀÇ WHEREÀý¿¡¼­ ¼ú¾îó·³ »ç¿ëÇÒ ¼öµµ ÀÖ½À´Ï´Ù. ¿¹¸¦ µé¾î, ´ÙÀ½ÀÇ ¸í·É¹®Àº "touched up"À̶ó´Â ÁÖ¼®ÀÌ ÀÖ´Â Á÷¿ø Å×À̺íÀÇ ¸ðµç À̹ÌÁö ÆÄÀÏ À̸§À» °Ë»öÇÕ´Ï´Ù.

EXEC SQL BEGIN DECLARE SECTION;
struct {
       short len;
       char data[250];
       }hvImg_fname
EXEC SQL END DECLARE SECTION;
 
EXEC SQL SELECT FILENAME(PICTURE)
     INTO :hvImg_fname
     FROM EMPLOYEE
     WHERE COMMENT(PICTURE)
           LIKE '%touch%up';


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