IBM Books

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

ÁÖ¼® ÀúÀå

UDF ¿äû¿¡¼­ ÁÖ¼®À» ÁöÁ¤ÇÏ¿© À̹ÌÁö, ¿Àµð¿À ¶Ç´Â ºñµð¿À ¿ÀºêÁ§Æ®¿Í ÇÔ²² ÁÖ¼®À» ÀúÀåÇϽʽÿÀ. ÁÖ¼®Àº ÃÖ´ë 32,700 ¹ÙÀÌÆ®±îÁö °¡´ÉÇÑ LONG VARCHAR µ¥ÀÌÅÍ À¯ÇüÀÇ ¹«Çü½Ä ÅØ½ºÆ®ÀÔ´Ï´Ù. ¿ÀºêÁ§Æ®¸¦ ÀúÀåÇÒ ¶§ ÁÖ¼®À» ÀúÀåÇÏÁö ¾ÊÀ¸·Á¸é, ³Î(NULL) °ªÀ̳ª ºó ¹®ÀÚ¿­À» ÁÖ¼® ´ë½Å ÁöÁ¤ÇϽʽÿÀ. ³Î(NULL) °ªÀ» ÁöÁ¤ÇÏ´Â °æ¿ì, ±×°ÍÀ» LONG VARCHAR µ¥ÀÌÅÍ À¯ÇüÀ¸·Î Á¦°øÇØ¾ß ÇÔÀ» ±â¾ïÇϽʽÿÀ.

¿¹¸¦ µé¾î, C ÀÀ¿ëÇÁ·Î±×·¥¿¡ ÀÖ´Â ´ÙÀ½ ¸í·É¹®Àº ºñµð¿À Ŭ¸³°ú ÇÔ²² ÁÖ¼®À» ÀúÀåÇÕ´Ï´Ù.

EXEC SQL BEGIN DECLARE SECTION;
  long hvStorageType;
EXEC SQL END DECLARE SECTION;
 
hvStorageType=MMDB_STORAGE_TYPE_EXTERNAL;
 
EXEC SQL INSERT INTO EMPLOYEE VALUES(
        '128557',
        'Anita Jones',
        DB2VIDEO(
          CURRENT SERVER,
          '/employee/videos/ajones.mpg',
          'MPEG1',
          :hvStorageType,
          'Anita''s video')                /* comment */
       );

C ÀÀ¿ëÇÁ·Î±×·¥¿¡ ÀÖ´Â ´ÙÀ½ ¸í·É¹®Àº ÁÖ¼® ¾øÀÌ À̹ÌÁö¸¦ ÀúÀåÇÕ´Ï´Ù.

EXEC SQL BEGIN DECLARE SECTION;
  long hvStorageType;
EXEC SQL END DECLARE SECTION;
 
hvStorageType=MMDB_STORAGE_TYPE_INTERNAL;
 
EXEC SQL INSERT INTO EMPLOYEE VALUES(
        '128557',
        'Anita Jones',
        DB2IMAGE(
          CURRENT SERVER,
          '/employee/images/ajones.bmp',
          'GIF',
          :hvStorageType,
          Cast(NULL as LONG
VARCHAR)            /* no comment */
       );


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