truncate lob

Truncates an LOB to a specified length.

Syntax

truncate lob locator_descriptor [ ( result_length)]

Parameters

Examples

Usage

If result_length is not specified or is 0 (zero), the SAP ASE server deallocates the LOB memory, and points the locator to a null LOB.

See alsolocator_valid, return_lob, create_locator in Reference Manual: Building Blocks .

Permissions

Any user can execute truncate lob.

Related reference
deallocate locator