15.00 - 5861 LOBs are not allowed to be part of a NOT IN expression. - 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)

5861 LOBs are not allowed to be part of a NOT IN expression.

Explanation:

LOBs are not allowed to be part of a NOT IN expression even if the LOB is cast to a non-LOB.

Generated By:

Optimizer Module.

For Whom:

End User.

Remedy:

The query must be re-written. It may be possible to define the LOB column as not nullable and have the query complete.