»ç¿ëÀÚ´Â Á÷¿ø Å×ÀÌºí¿¡ 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´Â ´ÙÀ½À» ¼öÇàÇÕ´Ï´Ù.
À̹ÌÁö ¼Ò½º°¡ ajones.bmp¶ó´Â ¼¹ö ÆÄÀÏ¿¡ ÀÖ½À´Ï´Ù. ÆÄÀÏ ³»¿ëÀº BLOBÀ¸·Î °ü¸® Áö¿ø Å×ÀÌºí ·¹Äڵ忡 »ðÀԵ˴ϴÙ. ÀúÀåµÈ À̹ÌÁöÀÇ Çü½ÄÀº ¼Ò½º À̹ÌÁö¿Í °°½À´Ï´Ù. Çü½Ä º¯È¯ÀÌ ¼öÇàµÇÁö ¾Ê½À´Ï´Ù.
INSERT¹®¿¡¼ DB2Audio UDF¿¡ ´ëÇÑ ÀÀ´äÀ¸·Î, Audio Extender´Â ´ÙÀ½À» ¼öÇàÇÕ´Ï´Ù.
¿Àµð¿À ³»¿ëÀº ajones.wav¶ó´Â ¼¹ö ÆÄÀÏ¿¡ ÀÖ½À´Ï´Ù. °ü¸® Áö¿ø Å×ÀÌºí ·¹Äڵ尡 ÆÄÀÏÀ» ÂüÁ¶ÇÕ´Ï´Ù.
Æ®¸®°Å´Â ´Ù¾çÇÑ °ü¸® Áö¿ø Å×ÀÌºí¿¡ À̹ÌÁö ¹× ¿Àµð¿À ¼Ó¼º µ¥ÀÌÅ͸¦ »ðÀÔÇÕ´Ï´Ù.