Image | Audio | Video |
---|---|---|
X | X | X |
Updates the content of an image, audio, or video that is stored in a database, and updates its comment.
Include file
Syntax
Update content from buffer or client file and update comment
>>-Replace--(--handle--,--content--,--source_format--,----------> >----target_file--,--comment--)--------------------------------><
Syntax
Update content from server file and update comment
>>-Replace--(--handle--,--source_file--,--source_format--,--stortype--,--> >---comment--)-------------------------------------------------><
Include file
Update content with user-supplied attributes from buffer or client file and update comment
>>-Replace--(--handle--,--content--,--target_file--,------------> >----comment--,--attrs--,--thumbnail--)------------------------><
Include file
Update content with user-supplied attributes from server file and update comment
>>-Replace--(--handle--,--source_file--,--stortype--,--comment--,--> >---attrs--,--thumbnail--)-------------------------------------><
Syntax
Update content from buffer or client file with format conversion and update comment--image only
>>-Replace--(--handle--,--content--,--source_format--,----------> >----target_format--,--target_file--,--comment--)--------------><
Syntax
Update content from server file with format conversion and update comment--image only
>>-Replace--(--handle--,--source_file--,--source_format--,------> >----target_format--,--target_file--,--comment--)--------------><
Syntax
Update content from buffer or client file with format conversion and additional changes and update comment--image only
>>-Replace--(--handle--,--content--,--source_format--,----------> >----target_format--,--target_file--,--conversion_options--,----> >----comment--)------------------------------------------------><
Syntax
Update content from server file with format conversion and additional changes and update comment--image only
>>-Replace--(--handle--,--source_file--,--source_format--,------> >----target_format--,--conversion_options--,--target_file--,----> >----comment--)------------------------------------------------><
Parameters (data type)
Return values (data type)
The handle of the image, audio, or video to be updated (DB2IMAGE, DB2AUDIO, or DB2VIDEO).
Examples
Update Anita Jones's image in the picture column of the employee table, convert the format of the image from BMP to GIF, and update the comment:
EXEC SQL BEGIN DECLARE SECTION; long hvStorageType; EXEC SQL END DECLARE SECTION; hvStorageType = MMDB_STORAGE_TYPE_INTERNAL; EXEC SQL UPDATE EMPLOYEE SET PICTURE = REPLACE(PICTURE, '/employee/newimg/ajones.bmp', 'BMP', 'GIF', :hvStorageType, 'Anita''s new picture') WHERE NAME='Anita Jones';