Content UDF´Â ¿À¹ö·ÎµåµÇ¸ç, UDF¸¦ »ç¿ëÇÏ´Â ¹æ¹ý¿¡ µû¶ó ¼·Î ´Ù¸¥ Çü½ÄÀ» °®°Ô µÇ´Â °ÍÀ» ÀǹÌÇÕ´Ï´Ù. Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.
Çü½Ä 1: ¿ÀºêÁ§Æ®¸¦ Ŭ¶óÀÌ¾ðÆ® ¹öÆÛ ¶Ç´Â Ŭ¶óÀÌ¾ðÆ® ÆÄÀÏ·Î °Ë»öÇÕ´Ï´Ù.
Content( handle, /* object handle */ );
Çü½Ä 2: ¿ÀºêÁ§Æ® ¼¼±×¸ÕÆ®¸¦ Ŭ¶óÀÌ¾ðÆ® ¹öÆÛ ¶Ç´Â Ŭ¶óÀÌ¾ðÆ® ÆÄÀÏ·Î °Ë»öÇÕ´Ï´Ù.
Content( handle, /* object handle */ offset, /* offset where retrieval begins */ size /* number of bytes to retrieve */ );
Çü½Ä 3: ¿ÀºêÁ§Æ®¸¦ ¼¹ö ÆÄÀÏ·Î °Ë»öÇÕ´Ï´Ù.
Content( handle, /* object handle */ target_file, /* server file name */ overwrite /* 0=Do not overwrite target file if it exists */ /* 1=Overwrite target file */ );
¶ÇÇÑ Content UDF´Â À̹ÌÁö ¿ÀºêÁ§Æ®ÀÇ °æ¿ì¿¡ ÇÑÇØ ´ÙÀ½ Çü½ÄÀ» Æ÷ÇÔÇÕ´Ï´Ù.
Çü½Ä 4: Çü½Ä º¯È¯À» »ç¿ëÇÏ¿© À̹ÌÁö¸¦ Ŭ¶óÀÌ¾ðÆ® ¹öÆÛ ¶Ç´Â ÆÄÀÏ·Î °Ë»öÇÕ´Ï´Ù.
Content( handle, /* object handle */ target format /* target format */ );
Çü½Ä 5: Çü½Ä º¯È¯À» »ç¿ëÇÏ¿© ¿ÀºêÁ§Æ®¸¦ ¼¹ö ÆÄÀÏ·Î °Ë»öÇÕ´Ï´Ù.
Content( handle, /* object handle */ target_file, /* server file name */ overwrite, /* 0=Do not overwrite target file if it exists */ /* 1=Overwrite target file */ target format /* target format */ );
Çü½Ä 6: Çü½Ä º¯È¯ ¹× Ãß°¡ º¯°æÀ» »ç¿ëÇÏ¿© ¿ÀºêÁ§Æ®¸¦ Ŭ¶óÀÌ¾ðÆ® ¹öÆÛ ¶Ç´Â ÆÄÀÏ·Î °Ë»öÇÕ´Ï´Ù.
Content( handle, /* object handle */ target format, /* target format */ conversion_options /* conversion options */ );
Çü½Ä 7: Çü½Ä º¯È¯ ¹× Ãß°¡ º¯°æÀ» »ç¿ëÇÏ¿© ¿ÀºêÁ§Æ®¸¦ ¼¹ö ÆÄÀÏ·Î °Ë»öÇÕ´Ï´Ù.
Content( handle, /* object handle */ target_file, /* server file name */ overwrite, /* 0=Do not overwrite target file if it exists */ /* 1=Overwrite target file */ target format, /* target format */ conversion_options /* conversion options */ );
¿¹¸¦ µé¾î, ´ÙÀ½ÀÇ ¸í·É¹®Àº Á÷¿ø Å×ÀÌºí¿¡¼ ¼¹ö¿¡ ÀÖ´Â ÆÄÀÏ·Î À̹ÌÁö¸¦ °Ë»öÇÕ´Ï´Ù. (À̰ÍÀº Çü½Ä 3¿¡ ´ëÀÀÇÕ´Ï´Ù.)
EXEC SQL SELECT CONTENT( /* retrieval UDF */ PICTURE, /* image handle */ '/employee/images/ajones.bmp', /* target file */ 1) /* overwrite target file */ FROM EMPLOYEE WHERE NAME = 'Anita Jones';
C ÀÀ¿ëÇÁ·Î±×·¥¿¡ ÀÖ´Â ´ÙÀ½ ¸í·É¹®Àº Á÷¿ø Å×ÀÌºí¿¡¼ ¼¹ö¿¡ ÀÖ´Â ÆÄÀÏ·Î À̹ÌÁö¸¦ °Ë»öÇÕ´Ï´Ù. À̹ÌÁö Çü½ÄÀº °Ë»öµÉ ¶§ º¯È¯µË´Ï´Ù. (À̰ÍÀº Çü½Ä 5¿¡ ´ëÀÀÇÕ´Ï´Ù.)
EXEC SQL BEGIN DECLARE SECTION; char hvImg_fname[255]; EXEC SQL END DECLARE SECTION; EXEC SQL SELECT CONTENT( /* retrieval UDF */ PICTURE, /* image handle */ '/employee/images/ajones.bmp', /* target file */ 1, /* overwrite target file */ 'GIF') /* target format */ INTO :hvImg_fname FROM EMPLOYEE WHERE NAME = 'Anita Jones';