IBM Books

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


Å×ÀÌºí¿¡ µ¥ÀÌÅÍ »ðÀÔ

»ç¿ëÀÚ´Â Á÷¿ø Å×ÀÌºí¿¡ Anita Jones¿¡ ´ëÇÑ ·¹Äڵ带 »ðÀÔÇÕ´Ï´Ù. ·¹Äڵ忡´Â AnitaÀÇ ID(128557), À̸§, »çÁø ¹× À½¼º ·¹ÄÚµùÀÌ ÀÖ½À´Ï´Ù. ¼Ò½º À̹ÌÁö¿Í ¿Àµð¿À ³»¿ëÀº ¼­¹öÀÇ ÆÄÀÏ¿¡ ÀÖ½À´Ï´Ù. À̹ÌÁö´Â BLOBÀ¸·Î Å×ÀÌºí¿¡ ÀúÀåµË´Ï´Ù. ¿Àµð¿À ³»¿ëÀº ¼­¹ö ÆÄÀÏ¿¡ ³²½À´Ï´Ù(Å×À̺í Ç׸ñÀÌ ¼­¹ö ÆÄÀÏÀ» ÂüÁ¶ÇÕ´Ï´Ù).

»ç¿ëÀÚ ¼öÇà ÀÛ¾÷: »ç¿ëÀÚ´Â ´ÙÀ½ ¿¹½Ã¿¡ ³ªÅ¸³­ ¸í·É¹®À» Æ÷ÇÔÇÏ´Â ÀÀ¿ëÇÁ·Î±×·¥À» »ç¿ëÇÏ¿© Á÷¿ø Å×ÀÌºí¿¡ ·¹Äڵ带 »ðÀÔÇÕ´Ï´Ù.



EXEC SQL BEGIN DECLARE SECTION;
long hvInt_Stor;
long hvExt_Stor;
EXEC SQL END DECLARE SECTION;
 
hvInt_Stor = MMDB_STORAGE_TYPE_INTERNAL;
hvExt_Stor = MMDB_STORAGE_TYPE_EXTERNAL;
 
EXEC SQL INSERT INTO EMPLOYEE VALUES(
        '128557',                          /*id*/
        'Anita Jones',                     /*name*/
        DB2IMAGE(                          /*Image Extender UDF*/
           CURRENT SERVER,                 /*database server name in*/
                                           /CURRENT SERVER register*/
           '/employee/images/ajones.bmp'   /*image source file*/
           'ASIS',                         /*keep the image format*/
           :hvInt_Stor,                    /*store image in DB as BLOB*/
           'Anita''s picture'),            /*comment*/
        DB2AUDIO(                          /*Audio Extender UDF*/
           CURRENT SERVER,                 /*database server name in*/
                                           /*CURRENT SERVER register*/
           '/employee/sounds/ajones.wav',  /*audio source file*/
           'WAVE',                         /* audio format */
           :hvExt_Stor,                    /*retain content in server file*/
           'Anita''s voice')               /*comment*/
       );

°á°ú: INSERT¹®¿¡ ÀÖ´Â DB2Image UDF¿¡ ´ëÇÑ ÀÀ´äÀ¸·Î, Image Extender´Â ´ÙÀ½À» ¼öÇàÇÕ´Ï´Ù.

INSERT¹®¿¡¼­ DB2Audio UDF¿¡ ´ëÇÑ ÀÀ´äÀ¸·Î, Audio Extender´Â ´ÙÀ½À» ¼öÇàÇÕ´Ï´Ù.

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


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