IBM Books

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

Thumbnail


Image Audio Video
X   X

µ¥ÀÌÅͺ£À̽º¿¡ ÀúÀåµÈ À̹ÌÁö ¶Ç´Â ºñµð¿À ÇÁ·¹ÀÓÀÇ ½æ³×ÀÏ Å©±â ¹öÀüÀ» ¸®ÅÏÇϰųª °»½ÅÇÕ´Ï´Ù.

Include ÆÄÀÏ

À̹ÌÁö
dmbimage.h

ºñµð¿À
dmbvideo.h

±¸¹®

½æ³×ÀÏ °Ë»ö

>>-Thumbnail--(--handle--)-------------------------------------><
 

±¸¹®

½æ³×ÀÏ °»½Å

>>-Thumbnail--(--handle--,--new_thumbnail--)-------------------><
 

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

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

new_thumbnail (LONG VARCHAR FOR BIT DATA)
½æ³×ÀÏ °»½ÅÀ» À§ÇÑ ¼Ò½º ³»¿ë.

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

°Ë»öÀÇ °æ¿ì, °Ë»öµÈ ½æ³×ÀÏÀÇ ³»¿ë(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';


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