deallocate locator

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

Syntax

deallocate locator locator_descriptor

Parameters

locator_descriptor – is a valid representation of a LOB locator: a host variable, a local variable, or the literal binary value of a locator.

Examples

Example 1 – Deallocates the LOB referenced by @v:
```
deallocate locator @v
```

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.

Parent topic: Commands

Related reference

Created May 28, 2014. Send feedback on this help topic to Technical Publications: pubs@sap.com