Image | Audio | Video |
---|---|---|
X | X |
µ¥ÀÌÅͺ£À̽º¿¡ ÀúÀåµÈ À̹ÌÁö ¶Ç´Â ºñµð¿À ÇÁ·¹ÀÓÀÇ ½æ³×ÀÏ Å©±â ¹öÀüÀ» ¸®ÅÏÇϰųª °»½ÅÇÕ´Ï´Ù.
Include ÆÄÀÏ
±¸¹®
½æ³×ÀÏ °Ë»ö
>>-Thumbnail--(--handle--)-------------------------------------><
±¸¹®
½æ³×ÀÏ °»½Å
>>-Thumbnail--(--handle--,--new_thumbnail--)-------------------><
¸Å°³º¯¼ö(µ¥ÀÌÅÍ À¯Çü)
¸®ÅÏ °ª(µ¥ÀÌÅÍ À¯Çü)
°Ë»öÀÇ °æ¿ì, °Ë»öµÈ ½æ³×ÀÏÀÇ ³»¿ë(LONG VARCHAR FOR BIT DATA). °»½ÅÀÇ °æ¿ì, À̹ÌÁö ¶Ç´Â ºñµð¿À ÇÚµé(DB2IMAGE ¶Ç´Â DB2VIDEO).
¿¹
employee Å×ÀÌºí¿¡ ÀúÀåµÈ Anita Jones À̹ÌÁöÀÇ ½æ³×ÀÏÀ» È®º¸ÇϽʽÿÀ.
EXEC SQL BEGIN DECLARE SECTION; struct{ short len; char data [32000]; }hvThumbnail; EXEC SQL END DECLARE SECTION; EXEC SQL SELECT THUMBNAIL(PICTURE) INTO :hvThumbnail FROM EMPLOYEE WHERE NAME = 'Anita Jones';
employee Å×ÀÌºí¿¡ ÀÖ´Â Anita Jones ºñµð¿À¿Í ¿¬°üµÈ ½æ³×ÀÏÀ» °»½ÅÇϽʽÿÀ.
EXEC SQL BEGIN DECLARE SECTION; struct { short len; char data[10000]; }hvThumbnail; EXEC SQL END DECLARE SECTION; /* Create thumbnail and */ /* store in hvThumbnail */ EXEC SQL UPDATE EMPLOYEE SET VIDEO=THUMBNAIL( VIDEO, :hvThumbnail) WHERE NAME='Anita Jones';