A locator is data containing a 4-byte value that identifies a specific data value on the server. The use of a locator allows you to process an SQL statement that handles data without storing the entity for the data on a client.
Table 1-37 Types of locators
Type | Description |
---|---|
BLOB locator | Has a value that identifies BLOB type data values on the server. |
BINARY locator | Has a value that identifies BINARY type data values on the server. |
Table 1-38 Locator specification method and locations where one can be specified
Type | Specification method | Specifiable locations |
---|---|---|
BLOB locator | Embedded variable | Anywhere a BLOB type embedded variable can be specified. |
BINARY locator | Embedded variable | Anywhere a BINARY type embedded variable can be specified. However, if the data type of the allocated data on the server is an embedded variable of a locator of the BINARY type with a maximum length of 32,001 bytes or greater, a BINARY locator can be specified only in those locations where BINARY-type embedded variables with a maximum length of 32,001 bytes or greater can be specified. |