Teradata Database Message 5921 - 5921 - Analytics Database - Teradata Vantage

Message

A SELECT AND CONSUME statement cannot be combined with a Update/Delete/UpSert/Merge statement in a request.

Explanation

The multi-statement request contains UPDATE/DELETE/UPSERT/MERGE combined with SELECT AND CONSUME statements and they are referring to the same queue table.

Generated By

RES modules.

For Whom

End User.

Notes

None

Remedy

Split the request into multiple requests.