Teradata Database Message 5861 - 5861 - Analytics Database - Teradata Vantage

Message

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.

Notes

None

Remedy

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