À̹ÌÁö, ¿Àµð¿À ¶Ç´Â ºñµð¿À ¿ÀºêÁ§Æ®·Î ÀúÀåµÈ ÁÖ¼®À» °Ë»öÇÏ·Á¸é, Comment UDF¸¦ »ç¿ëÇϽʽÿÀ. ¿ÀºêÁ§Æ®¿¡ ´ëÇÑ ÁÖ¼® °Ë»ö½Ã, ¿ÀºêÁ§Æ® ÇÚµéÀÌ ÀÖ´Â µ¥ÀÌÅͺ£À̽º Å×ÀÌºí¿¡¼ Ä÷³À» ÁöÁ¤ÇÕ´Ï´Ù. ¿¹¸¦ µé¾î, ´ÙÀ½ÀÇ ¸í·É¹®Àº Á÷¿ø Å×ÀÌºí¿¡ ¿Àµð¿À Ŭ¸³À» »ç¿ëÇÏ¿© ÀúÀåµÈ ÁÖ¼®À» °Ë»öÇÕ´Ï´Ù.
EXEC SQL BEGIN DECLARE SECTION; struct { short len; char data[32700]; }hvComment EXEC SQL END DECLARE SECTION; EXEC SQL SELECT COMMENT(SOUND) INTO :hvComment FROM EMPLOYEE WHERE NAME = 'Anita Jones';
Comment UDF¸¦ SQL Á¶È¸ÀÇ WHEREÀý¿¡¼ ¼ú¾îó·³ »ç¿ëÇÒ ¼öµµ ÀÖ½À´Ï´Ù. ¿¹¸¦ µé¾î, ´ÙÀ½ÀÇ ¸í·É¹®Àº "touched up"À̶ó´Â ÁÖ¼®ÀÌ ÀÖ´Â Á÷¿ø Å×À̺íÀÇ ¸ðµç À̹ÌÁö ÆÄÀÏ À̸§À» °Ë»öÇÕ´Ï´Ù.
EXEC SQL BEGIN DECLARE SECTION; struct { short len; char data[250]; }hvImg_fname EXEC SQL END DECLARE SECTION; EXEC SQL SELECT FILENAME(PICTURE) INTO :hvImg_fname FROM EMPLOYEE WHERE COMMENT(PICTURE) LIKE '%touch%up';