»ç¿ëÀÚ ÀÚ½ÅÀÇ Çü½ÄÀÇ À̹ÌÁö ÀúÀå½Ã, À̹ÌÁöÀÇ ¼ÒÇü ¹öÀüÀÎ ½æ³×ÀÏÀ» ÀúÀåÇÒ ¼öµµ ÀÖ½À´Ï´Ù. »ç¿ëÀÚ´Â ½æ³×ÀÏÀÇ Å©±â¿Í Çü½ÄÀ» Á¦¾îÇÕ´Ï´Ù. Image Extender°¡ ÀνÄÇÏ´Â Çü½Ä¿¡ À̹ÌÁö ÀúÀå½Ã, ¿ÀºêÁ§Æ®À¸·Î ´ëÇØ ½æ³×ÀÏÀ» ÀÚµ¿À¸·Î »ý¼ºÇϰí ÀúÀåÇÕ´Ï´Ù. Image Extender´Â 112 x 84 Çȼ¿ Å©±âÀÇ GIF Çü½ÄÀ¸·Î ½æ³×ÀÏÀ» ¸¸µì´Ï´Ù.
»ç¿ëÀÚ ÀÚ½ÅÀÇ Çü½ÄÀÇ ºñµð¿À ¿ÀºêÁ§Æ® ÀúÀå½Ã, ºñµð¿À ¿ÀºêÁ§Æ®¸¦ »ó¡ÇÏ´Â ½æ³×ÀÏÀ» ÀúÀåÇÒ ¼öµµ ÀÖ½À´Ï´Ù. Video Extender°¡ ÀνÄÇÏ´Â Çü½ÄÀ¸·Î ºñµð¿À ¿ÀºêÁ§Æ® ÀúÀå½Ã, ¿ÀºêÁ§Æ®¿¡ ´ëÇÑ ÀÏ¹Ý ½æ³×ÀÏÀ» ÀÚµ¿À¸·Î ÀúÀåÇÕ´Ï´Ù. Video Extender´Â 108 x 78 Çȼ¿ Å©±âÀÇ GIF Çü½ÄÀ¸·Î ½æ³×ÀÏÀ» ¸¸µì´Ï´Ù.
»ç¿ëÀÚ Á¦°ø ¼Ó¼ºÀ» »ç¿ëÇÏ¿© À̹ÌÁö ¶Ç´Â ºñµð¿À ¿ÀºêÁ§Æ®¸¦ ÀúÀåÇÒ ¶§ ½æ³×ÀÏÀ» ÀúÀåÇÏÁö ¾ÊÀ¸·Á¸é, ½æ³×ÀÏ¿¡ ³Î(NULL) °ª ¶Ç´Â ºó ¹®ÀÚ¿À» ÁöÁ¤ÇϽʽÿÀ.
ÇÁ·Î±×·¥¿¡¼ ½æ³×ÀÏÀ» »ý¼ºÇϽʽÿÀ. Extender´Â ½æ³×ÀÏÀ» »ý¼ºÇÏ´Â API¸¦ Á¦°øÇÏÁö ¾Ê½À´Ï´Ù. ÇÁ·Î±×·¥¿¡ ½æ³×ÀÏ¿ë ±¸Á¶¸¦ ¸¸µé¾î UDF ³»¿¡ ½æ³×ÀÏ ±¸Á¶¸¦ ÁöÁ¤ÇϽʽÿÀ.
C ÀÀ¿ëÇÁ·Î±×·¥¿¡ ÀÖ´Â ´ÙÀ½ ¸í·É¹®Àº µ¥ÀÌÅͺ£À̽º Å×ÀÌºí¿¡ ºñµð¿À Ŭ¸³ÀÌ ÀÖ´Â ÇàÀ» ÀúÀåÇÕ´Ï´Ù. ³»¿ëÀÌ ¼¹ö ÆÄÀÏ¿¡ ÀÖ´Â ¼Ò½º ºñµð¿À Ŭ¸³Àº »ç¿ëÀÚ Á¤ÀÇ Çü½ÄÀ¸·Î µÇ¾î ÀÖ½À´Ï´Ù. ºñµð¿À ³»¿ëÀº ¼¹ö¿¡ ³²°í Å×ÀÌºí¿¡¼ Áö½ÃµË´Ï´Ù. ´ëÇ¥ ºñµð¿À ÇÁ·¹ÀÓÀÇ ½æ³×Àϵµ ÀúÀåµË´Ï´Ù.
EXEC SQL BEGIN DECLARE SECTION; long hvStorageType; struct { short len; char data[4000]; }hvVidattrs; struct { short len; char data[10000]; }hvThumbnail; EXEC SQL END DECLARE SECTION; MMDBVideoAttrs *pvideoAttr; hvStorageType=MMDB_STORAGE_TYPE_EXTERNAL; pvideoAttr=(MMDBVideoAttrs *) hvVidattrs.data; strcpy(pvideoAttr>cFormat,"Formatv"); hvVidattrs.len=sizeof(MMDBVideoAttrs); /* Generate thumbnail and assign data in video structure */ EXEC SQL INSERT INTO EMPLOYEE VALUES( '128557', 'Anita Jones', DB2VIDEO( CURRENT SERVER, '/employee/videos/ajones.vid', :hvStorageType, 'Anita''s video', :hvVidattrs, :hvThumbnail) /* Thumbnail*/ );