15.00 - 5767 The Locator is invalid because this request is in a different transaction. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

5767 The Locator is invalid because this request is in a different transaction.

Explanation:

The Locator referenced in the SQL statement is not valid because the Select to fetch the LOB is in a different transaction then the Select that created the locator.

Generated By:

Dis modules (DisLocValid).

For Whom:

End User.

Remedy:

Keep both Selects in the same transaction or create a static Locator (LobSelect = 'S' in the Options parcel).