IBM Books

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

Format


Image Audio Video
X X X

À̹ÌÁö³ª ¿Àµð¿À ¶Ç´Â ºñµð¿À Çü½ÄÀ» ¸®ÅÏÇÕ´Ï´Ù.

Include ÆÄÀÏ

À̹ÌÁö
dmbimage.h

¿Àµð¿À
dmbaudio.h

ºñµð¿À
dmbvideo.h

±¸¹®

>>-Format--(--handle--)----------------------------------------><
 

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

handle(DB2IMAGE, DB2AUDIO ¶Ç´Â DB2VIDEO)
À̹ÌÁö, ¿Àµð¿À ¶Ç´Â ºñµð¿À ÇÚµéÀ» Æ÷ÇÔÇÏ´Â Ä÷³ À̸§À̳ª È£½ºÆ® º¯¼ö.

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

À̹ÌÁö, ¿Àµð¿À ¶Ç´Â ºñµð¿À Çü½Ä(VARCHAR(8)). Áö¿øµÇ´Â À̹ÌÁö, ¿Àµð¿À ¹× ºñµð¿À Çü½Ä¿¡ ´ëÇØ¼­´Â Ç¥ 4¸¦ ÂüÁ¶ÇϽʽÿÀ.

¿¹

employee Å×À̺íÀÇ picture Ä÷³¿¡ ÀúÀåµÈ GIF Çü½ÄÀ¸·Î À̹ÌÁöÀÇ ¸ðµç Á÷¿ø À̸§À» È®º¸ÇϽʽÿÀ.

EXEC SQL BEGIN DECLARE SECTION;
char hvName[30];
EXEC SQL END DECLARE SECTION;
 
EXEC SQL SELECT NAME
     INTO :hvName
     FROM EMPLOYEE
     WHERE FORMAT(PICTURE)='GIF';


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