º°µµ·Î ÁÖ¼®À» °»½ÅÇϰųª, ¿¬°üµÈ ¿ÀºêÁ§Æ® °»½Å½Ã ÁÖ¼®À» °»½ÅÇÒ ¼ö ÀÖ½À´Ï´Ù.
ÁÖ¼®À» °»½ÅÇÏ·Á¸é, Comment UDF¸¦ »ç¿ëÇϽʽÿÀ. ¿ÀºêÁ§Æ® ÇÚµéÀÌ ÀÖ´Â Å×À̺í Ä÷³°ú ÇÔ²², °»½ÅµÈ ÁÖ¼®ÀÇ ³»¿ëÀ» ÁöÁ¤ÇϽʽÿÀ. ³»¿ëÀ» ¼¹ö·Î Àü¼ÛÇÏ·Á¸é È£½ºÆ® º¯¼ö¸¦ »ç¿ëÇϽʽÿÀ. ¿¹¸¦ µé¾î, ´ÙÀ½ÀÇ ¸í·É¹®Àº hvRemarks·Î À̸§ ÁöÁ¤µÈ È£½ºÆ® º¯¼ö¸¦ ¼±¾ðÇϰí, ±×°ÍÀ» »ç¿ëÇÏ¿© ÀúÀåµÈ ºñµð¿À Ŭ¸³¿¡ ´ëÇÑ ±âÁ¸ ÁÖ¼®À» °»½ÅÇÕ´Ï´Ù.
EXEC SQL BEGIN DECLARE SECTION; struct { short len; char data [40]; }hvRemarks; EXEC SQL END DECLARE SECTION; /* Get the old comment */ EXEC SQL SELECT COMMENT(VIDEO) INTO :hvRemarks FROM EMPLOYEE WHERE NAME = 'Anita Jones'; /* Append to old comment */ hvRemarks.data[Remarks.len]='\0'; hvRemarks.len=strlen(hvRemarks.data); strcat (hvRemarks.data, "Updated video"); EXEC SQL UPDATE EMPLOYEE SET VIDEO=COMMENT(VIDEO, :hvRemarks) WHERE NAME = 'Anita Jones';
¿¬°üµÈ ¿ÀºêÁ§Æ® °»½Å½Ã, ÁÖ¼®À» °»½ÅÇÏ·Á¸é Replace UDF¸¦ »ç¿ëÇϽʽÿÀ. ¿¹¸¦ µé¾î, ´ÙÀ½ÀÇ ¸í·É¹®Àº °ü·ÃµÈ ÁÖ¼®°ú ÇÔ²² ¼¹ö ÆÄÀÏ¿¡ ÀúÀåµÈ ºñµð¿À Ŭ¸³À» °»½ÅÇÕ´Ï´Ù.
EXEC SQL BEGIN DECLARE SECTION; long hvStorageType; EXEC SQL END DECLARE SECTION; hvStorageType=MMDB_STORAGE_TYPE_EXTERNAL; EXEC SQL UPDATE EMPLOYEE SET VIDEO=REPLACE( VIDEO, '/employee/newvid/ajones.mpg', 'MPEG1', :hvStorageType, 'Anita''s new video') /*updated comment*/ WHERE NAME='Anita Jones';