IBM Books

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


Å×À̺íÀÇ µ¥ÀÌÅÍ °»½Å

Anita Jones´Â Á÷¿ø Å×ÀÌºí¿¡¼­ ÀÚ½ÅÀÇ »çÁøÀ» ÃֽŠ»çÁøÀ¸·Î ¹Ù²ß´Ï´Ù. ´õ¿í »õ·Î¿î »çÁø ³»¿ëÀº ¼­¹ö ÆÄÀÏ¿¡ ÀÖ½À´Ï´Ù.

»ç¿ëÀÚ ¼öÇà ÀÛ¾÷: »ç¿ëÀÚ´Â ´ÙÀ½ ¿¹½Ã¿¡ Ç¥½ÃµÈ SQL¹®À» Æ÷ÇÔÇÏ´Â ÀÀ¿ëÇÁ·Î±×·¥À» »ç¿ëÇÏ¿© Á÷¿ø Å×À̺íÀÇ »çÁøÀ» ´ëüÇÕ´Ï´Ù.



EXEC SQL BEGIN DECLARE SECTION;
  char hvComment [16385];
  long hvStorageType;
EXEC SQL END DECLARE SECTION;
 
strcpy(hvComment, "Picture taken at Anita's promotion");
hvStorageType=MMDB_STORAGE_TYPE_INTERNAL;
 
EXEC SQL UPDATE EMPLOYEE
       SET PICTURE=REPLACE(
              PICTURE,                      /*image handle*/
              '/myimages/newone.bmp',       /*source image content*/
              'BMP',                        /*source format*/
              :hvStorageType,               /*store image in table as BLOB*/
              :hvComment)                   /*replace comment*/
       WHERE NAME='Anita Jones';

°á°ú: UPDATE¹®ÀÇ Replace UDF¿¡ ´ëÇÑ ÀÀ´äÀ¸·Î, Image Extender°¡ »õ·Î¿î À̹ÌÁöÀÇ ¼Ó¼ºÀ» ÀнÀ´Ï´Ù. Image Extender´Â »õ·Î¿î À̹ÌÁöÀÇ ¼Ó¼ºÀ» »ç¿ëÇÏ¿© ±âÁ¸ À̹ÌÁö¿¡ ´ëÇÑ °ü¸® Áö¿ø Å×ÀÌºí¿¡ ÀúÀåµÈ ¼Ó¼ºÀ» °»½ÅÇÕ´Ï´Ù. À̹ÌÁö ¼Ò½º´Â newone.bmp¶ó´Â ¼­¹ö ÆÄÀÏ¿¡ ÀÖ½À´Ï´Ù. ÆÄÀÏ ³»¿ëÀº ÀÌÀü À̹ÌÁöÀÇ BLOB ³»¿ëÀ» ´ëüÇϸç BLOBÀ¸·Î¼­ °ü¸® Áö¿ø Å×ÀÌºí ·¹Äڵ忡 »ðÀԵ˴ϴÙ.

Æ®¸®°Å´Â ´Ù¾çÇÑ °ü¸® Áö¿ø Å×ÀÌºí¿¡ ÀÖ´Â À̹ÌÁö ¼Ó¼º µ¥ÀÌÅ͸¦ ´ëüÇÕ´Ï´Ù.


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