DB2 Version 9.7 for Linux, UNIX, and Windows

APPEND procedures - Append one large object to another

The APPEND procedures provide the capability to append one large object to another.

Note: Both large objects must be of the same type.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-DBMS_LOB.APPEND_BLOB--(--dest_lob--,--src_lob--)------------><


Read syntax diagramSkip visual syntax diagram
>>-DBMS_LOB.APPEND_CLOB--(--dest_lob--,--src_lob--)------------><

Parameters

dest_lob
An input or output argument of type BLOB(10M) or CLOB(10M) that specifies the large object locator for the destination object. Must be the same data type as src_lob.
src_lob
An input argument of type BLOB(10M) or CLOB(10M) that specifies the large object locator for the source object. Must be the same data type as dest_lob.

Authorization

EXECUTE privilege on the DBMS_LOB module.

Parent topic: DBMS_LOB module