IBM Books

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

ÁÖ¼® °»½Å

º°µµ·Î ÁÖ¼®À» °»½ÅÇϰųª, ¿¬°üµÈ ¿ÀºêÁ§Æ® °»½Å½Ã ÁÖ¼®À» °»½ÅÇÒ ¼ö ÀÖ½À´Ï´Ù.

ÁÖ¼®À» °»½ÅÇÏ·Á¸é, 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';


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