15.00 - 5921 A SELECT AND CONSUME statement cannot be combined with a Update/Delete/UpSert/Merge statement in a request. - 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)

5921 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.

Remedy:

Split the request into multiple requests.