deallocate locator

Deletes a large object (LOB) stored in memory and invalidates its LOB locator.

Syntax

deallocate locator locator_descriptor

Parameters

Examples

Usage

  • Use deallocate locator within a transaction. The SAP ASE server automatically deallocates each locator at the end of a transaction.

  • deallocate locator can conserve memory. When many LOB locators are created within a transaction, use deallocate locator to remove individual LOBs and locators when they are no longer needed.

See also locator_literal, locator_valid, return_lob, create_locator in Reference Manual: Building Blocks.

Permissions

Any user can execute deallocate locator.

Related reference
truncate lob