Image | Audio | Video |
---|---|---|
X | X | X |
À̹ÌÁö, ¿Àµð¿À ¶Ç´Â ºñµð¿À¿Í ÇÔ²² ÀúÀåµÈ ÁÖ¼®À» ¸®ÅÏÇϰųª °Ë»öÇÕ´Ï´Ù.
Include ÆÄÀÏ
±¸¹®
ÁÖ¼® °Ë»ö
>>-Comment--(--handle--)---------------------------------------><
±¸¹®
ÁÖ¼® °»½Å
>>-Comment--(--handle--,--new_comment--)-----------------------><
¸Å°³º¯¼ö(µ¥ÀÌÅÍ À¯Çü)
¸®ÅÏ °ª(µ¥ÀÌÅÍ À¯Çü)
°»½ÅÀÇ °æ¿ì À̹ÌÁö³ª ¿Àµð¿À ¶Ç´Â ºñµð¿ÀÀÇ ÇÚµé(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';