IBM Books

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

Ŭ¶óÀÌ¾ðÆ®¿¡ »óÁÖÇÏ´Â ¿ÀºêÁ§Æ® ÀúÀå

À̹ÌÁö, ¿Àµð¿À ¶Ç´Â ºñµð¿À ¿ÀºêÁ§Æ® ³»¿ëÀ» Ŭ¶óÀÌ¾ðÆ® ¹öÆÛ³ª Ŭ¶óÀÌ¾ðÆ® ÆÄÀÏ¿¡¼­ ¼­¹ö·Î Àü¼ÛÇϴ ȣ½ºÆ® º¯¼ö ¶Ç´Â ÆÄÀÏ ÂüÁ¶ º¯¼ö¸¦ »ç¿ëÇϽʽÿÀ.

¿ÀºêÁ§Æ®°¡ Ŭ¶óÀÌ¾ðÆ® ÆÄÀÏ¿¡ ÀÖ´Ù¸é, ÀúÀåÇÒ ¿ÀºêÁ§Æ®ÀÇ ³»¿ëÀ» ¼­¹ö·Î Àü¼ÛÇϱâ À§ÇØ ÆÄÀÏ ÂüÁ¶ º¯¼ö¸¦ »ç¿ëÇϽʽÿÀ. ¿¹¸¦ µé¾î, C ÀÀ¿ëÇÁ·Î±×·¥¿¡ ÀÖ´Â ´ÙÀ½ÀÇ ¸í·É¹®Àº Audio_fileÀ̶ó´Â ÆÄÀÏ ÂüÁ¶ º¯¼ö¸¦ Á¤ÀÇÇϰí À̸¦ »ç¿ëÇÏ¿© ³»¿ëÀÌ Å¬¶óÀÌ¾ðÆ® ÆÄÀÏ¿¡ ÀÖ´Â ¿Àµð¿À Ŭ¸³À» Àü¼ÛÇÕ´Ï´Ù. ¿Àµð¿À Ŭ¸³Àº ¼­¹öÀÇ µ¥ÀÌÅͺ£À̽º Å×ÀÌºí¿¡ ÀúÀåµË´Ï´Ù. ÆÄÀÏ ÂüÁ¶ º¯¼öÀÇ file_option Çʵ尡 ÀԷ¿ë SQL_FILE_READ·Î ¼³Á¤µÇ¾úÀ½À» À¯ÀÇÇϽʽÿÀ. ¶ÇÇÑ ÆÄÀÏ ÂüÁ¶ º¯¼ö°¡ ³»¿ë Àμö·Î DB2Audio UDF¿¡ »ç¿ëµÇ¾úÀ½À» À¯ÀÇÇϽʽÿÀ.

EXEC SQL BEGIN DECLARE SECTION;
  SQL TYPE IS BLOB_FILE Audio_file;
EXEC SQL END DECLARE SECTION;
 
strcpy (Audio_file.name, "/employee/sounds/ajones.wav");
Audio_file.name_length= strlen(Audio_file.name);
Audio_file.file_options= SQL_FILE_READ;
 
EXEC SQL INSERT INTO EMPLOYEE VALUES(
        '128557',
        'Anita Jones',
        DB2AUDIO(
          CURRENT SERVER,
          :Audio_file,          /* file reference variable */
          'WAVE',
          CAST(NULL as LONG VARCHAR),
          
          'Anita''s voice')
      );

¿ÀºêÁ§Æ®°¡ Ŭ¶óÀÌ¾ðÆ® ¹öÆÛ¿¡ ÀÖ´Ù¸é, BLOB ¶Ç´Â BLOB_LOCATOR·Î Á¤ÀÇµÈ È£½ºÆ® º¯¼ö¸¦ »ç¿ëÇÏ¿© ¼­¹ö¿¡ ÀúÀåÇÒ ³»¿ëÀ» Àü¼ÛÇϽʽÿÀ. ´ÙÀ½ÀÇ C ÀÀ¿ëÇÁ·Î±×·¥ ¸í·É¹®¿¡¼­´Â Video_loc¶ó´Â È£½ºÆ® º¯¼ö¸¦ »ç¿ëÇÏ¿© ¼­¹ö¿¡ ÀúÀåÇÒ ºñµð¿À Ŭ¸³ÀÇ ³»¿ëÀ» Àü¼ÛÇÕ´Ï´Ù. ºñµð¿À Ŭ¸³Àº BLOBÀ¸·Î µ¥ÀÌÅͺ£À̽º Å×ÀÌºí¿¡ ÀúÀåµË´Ï´Ù. È£½ºÆ® º¯¼ö°¡ ³»¿ë Àμö·Î DB2Video UDF¿¡ »ç¿ëµÇ¾úÀ½À» À¯ÀÇÇϽʽÿÀ.

EXEC SQL BEGIN DECLARE SECTION;
  SQL TYPE IS BLOB_LOCATOR Video_loc;
EXEC SQL END DECLARE SECTION;
 
EXEC SQL INSERT INTO EMPLOYEE VALUES(
        '128557',
        'Anita Jones',
        DB2VIDEO(
          CURRENT SERVER,
          :Video_loc,         /* host variable */
          'MPEG1',
          '',
          'Anita''s video')
       );

UDF ¸Þ¸ð¸®°¡ ÃæºÐÇÑÁö È®ÀÎÇϽʽÿÀ. ³»¿ëÀÌ Å¬¶óÀÌ¾ðÆ® ¹öÆÛ¿¡ ÀÖ´Â ¿ÀºêÁ§Æ®¸¦ ÀúÀåÇÒ ¶§, µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥ ±¸¼ºÀÇ UDF_MEM_SZ ¸Å°³º¯¼ö°¡ 4MB ÀÌ»óÀ¸·Î ¼³Á¤µÇ¾ú´ÂÁö È®ÀÎÇϽʽÿÀ.

DB2 ¸í·É UPDATE DATABASE MANAGER CONFIGURATIONÀ» »ç¿ëÇÏ¿© UDF_MEM_SZ ¸Å°³º¯¼ö¸¦ °»½ÅÇÒ ¼ö ÀÖ½À´Ï´Ù.

UPDATE DATABASE MANAGER ¸í·É¿¡ °üÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº DB2 Command Reference¸¦ ÂüÁ¶ÇϽʽÿÀ.


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