Updating the data of an existing smart large object

About this task

To update the data of an existing smart large object:

Procedure

  1. Use the SELECT statement to obtain the LO handle that identifies the location of the data.

    For more information, see Selecting the LO handle.

  2. Open the smart large object to obtain an LO file descriptor.

    For more information, see Open a smart large object.

  3. Read data from and write data to the open smart large object.

    For more information, see Read data from a smart large object and Write data to a smart large object.

  4. Close the smart large object.

    For more information, see Free a smart large object.

Results

Important: To update data of an existing smart large object, you do not need to use the UPDATE statement to update the CLOB, BLOB, or opaque-type column. The LO handle in the column does not need to change if you modify only the smart-large-object data.