IBM Books

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

Comment


Image Audio Video
X X X

À̹ÌÁö, ¿Àµð¿À ¶Ç´Â ºñµð¿À¿Í ÇÔ²² ÀúÀåµÈ ÁÖ¼®À» ¸®ÅÏÇϰųª °Ë»öÇÕ´Ï´Ù.

Include ÆÄÀÏ

À̹ÌÁö
dmbimage.h

¿Àµð¿À
dmbaudio.h

ºñµð¿À
dmbvideo.h

±¸¹®

ÁÖ¼® °Ë»ö

>>-Comment--(--handle--)---------------------------------------><
 

±¸¹®

ÁÖ¼® °»½Å

>>-Comment--(--handle--,--new_comment--)-----------------------><
 

¸Å°³º¯¼ö(µ¥ÀÌÅÍ À¯Çü)

handle(DB2IMAGE, DB2AUDIO ¶Ç´Â DB2VIDEO)
À̹ÌÁö, ¿Àµð¿À ¶Ç´Â ºñµð¿À ÇÚµéÀ» Æ÷ÇÔÇÏ´Â Ä÷³ À̸§À̳ª È£½ºÆ® º¯¼ö.

new_comment(LONG VARCHAR)
°»½ÅÇÒ »õ ÁÖ¼®. ³Î(NULL) °ª ¶Ç´Â ºó ¹®ÀÚ¿­Àº ±âÁ¸ ÁÖ¼®À» »èÁ¦ÇÕ´Ï´Ù.

¸®ÅÏ °ª(µ¥ÀÌÅÍ À¯Çü)

°»½ÅÀÇ °æ¿ì À̹ÌÁö³ª ¿Àµð¿À ¶Ç´Â ºñµð¿ÀÀÇ ÇÚµé(DB2MAGE, DB2AUDIO ¶Ç´Â DB2VIDEO). °Ë»öÀÇ °æ¿ì ÁÖ¼®(LONG VARCHAR).

¿¹

°ü·Ã ÁÖ¼®¿¡ "confidential" ´Ü¾î°¡ ÀÖ´Â employeeÀÇ picture Ä÷³¿¡¼­ ¸ðµç À̹ÌÁöÀÇ ÆÄÀÏ À̸§À» È®º¸ÇϽʽÿÀ.

EXEC SQL BEGIN DECLARE SECTION;
 char hvImg_fname[255;
EXEC SQL END DECLARE SECTION;
 
EXEC SQL SELECT FILENAME(PICTURE)
     INTO :hvImg_fname
     FROM EMPLOYEE
     WHERE COMMENT(PICTURE)
        LIKE '%confidential%';

employee Å×À̺íÀÇ video Ä÷³¿¡ ÀÖ´Â Anita JonesÀÇ ºñµð¿À Ŭ¸³°ú ¿¬°üµÈ ÁÖ¼®À» °»½ÅÇϽʽÿÀ.

EXEC SQL BEGIN DECLARE SECTION;
struct{
      short len;
      char data[4000];
      }hvRemarks;
EXEC SQL END DECLARE SECTION;
 
/* Get the old comment */
 
EXEC SQL SELECT COMMENT(VIDEO)
     INTO :hvRemarks
     FROM EMPLOYEE
     WHERE NAME =  'Anita Jones';
 
/* Update the comment */
 
hvRemarks.data[hvRemarks.len]='\0';
strcat (hvRemarks.data, "Updated video");
hvRemarks.len=strlen(hvRemarks.data);
 
EXEC SQL UPDATE EMPLOYEE
     SET VIDEO=COMMENT(VIDEO, :hvRemarks)
     WHERE NAME =  'Anita Jones';


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