Use the Content UDF in an SQL UPDATE statement to update an image, audio, or video object in a database table. Use the Replace UDF in an SQL UPDATE statement to update an image, audio, or video in a database table and update a comment that is associated with the object. In either case, the extender updates the attributes that are associated with the object.
You can update an object that is stored in a database table as a BLOB or stored in a server file (and pointed to from the database). The source of the update can be in a buffer, client file, or server file.
Table 4 lists the formats in which you can update image, audio, and video objects. However, you can also update an object whose format is unrecognized by the extender. In this case, the user specified the object's attributes when the object was stored. When you update an object with user-specified attributes, you need to specify the updated attributes of the object.Use the ContentA UDF in an SQL UPDATE statement to update an image, audio, or video object with user-supplied attributes in a database. Use the ReplaceA UDF in an SQL UPDATE statement to update an image, audio, or video with user-supplied attributes in a database table and update a comment associated with the object. When you update an object with user-specified attributes, you need to specify the attributes of the object, its format, and for video objects only, its compression format.
You can also update the thumbnail for a stored image or video.
Commit the update operation: Commit the unit of work after you update an image, audio, or video object in a database. This frees up locks that the extenders hold so that you can perform subsequent update operations on the stored object.