Teradata Database Message 5922 - 5922 - Analytics Database - Teradata Vantage

Message

A SELECT AND CONSUME statement must use non-LOB transforms for UDTs.

Explanation

To SELECT AND CONSUME UDTs and CDTs such as JSON, XML and ST_GEOMETRY from Queue Table, non-LOB transforms such as VARCHAR / VARBYTE needs to be used.

Generated By

OPT modules.

For Whom

End User.

Notes

None

Remedy

Logon with a user with non-LOB transforms settings to SELECT AND CONSUME the row.