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 */ );