Teradata Database Message 5767 - 5767 - Analytics Database - Teradata Vantage

Message

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.

Notes

None

Remedy

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