locator_valid

Determines whether a LOB locator is valid.

Syntax

locator_valid (locator_descriptor)

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

Example 1 – Validates the locator value 0x9067ef4501000000001000000040100400800000000:

locator_valid (0x9067ef4501000000001000000040100400800000000)
-------------------
                   1

locator_valid returns 1 if the specified locator is valid. Otherwise, it returns 0 (zero).
A locator becomes invalid if invalidated by the deallocate lob command, or at the termination of a transaction.

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

Any user can execute locator_valid.