DB2 10.5 for Linux, UNIX, and Windows

TRIM procedures - Truncate a large object to the specified length

The TRIM procedures provide the capability to truncate a large object to the specified length.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-DBMS_LOB.TRIM_BLOB--(--lob_loc--,--newlen--)----------------><


Read syntax diagramSkip visual syntax diagram
>>-DBMS_LOB.TRIM_CLOB--(--lob_loc--,--newlen--)----------------><

Parameters

lob_loc
An input or output argument of type BLOB(10M) or CLOB(10M) that specifies the large object locator of the large object to be trimmed.
newlen
An input argument of type INTEGER that specifies the new number of bytes or characters to which the large object is to be trimmed.

Authorization

EXECUTE privilege on the DBMS_LOB module.