DB2 10.5 for Linux, UNIX, and Windows

WRITEAPPEND procedures - Append data to the end of a large object

The WRITEAPPEND procedures provide the capability to add data to the end of a large object.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-DBMS_LOB.WRITEAPPEND_BLOB--(--lob_loc--,--amount--,--buffer--)-><


Read syntax diagramSkip visual syntax diagram
>>-DBMS_LOB.WRITEAPPEND_CLOB--(--lob_loc--,--amount--,--buffer--)-><

Parameters

lob_loc
An input or output argument of type BLOB or CLOB that specifies the large object locator of the large object to which data is to appended.
amount
An input argument of type INTEGER that specifies the number of bytes or characters from buffer to be appended to the large object.
buffer
An input argument of type BLOB(32767) or VARCHAR(32672) that contains the data to be appended to the large object. If lob_loc is a BLOB, then buffer must be BLOB. If lob_loc is a CLOB, then buffer must be VARCHAR.

Authorization

EXECUTE privilege on the DBMS_LOB module.