locator_literal

Identifies a binary value as a locator literal.

Syntax

locator_literal(locator_type, literal_locator)

Parameters

locator_type – is the type of locator. One of text_locator, image_locator, or unitext_locator.
literal_locator – is the actual binary value of a LOB locator.

Examples

Example 1 – This example inserts an image LOB that is stored in memory and identified by its locator in the imagecol column of my_table. Use of the locator_literal function ensures that the SAP ASE server correctly interprets the binary value as a LOB locator.
```
insert my_table (imagecol) values
    (locator_literal(image_locator, 0x9067ef4501000000001000000040100400800000000)
```

Usage

Use locator_literal to ensure that the SAP ASE server correctly identifies the literal locator value and does not misinterpret it as an image or other binary.

See also deallocate locator, truncate lob in Reference Manual: Commands.

Permissions

Any user can execute locator_literal.