Symptom
During syntax check, following syntax error is raised:
The addition or variable with ID "XXX" is not allowed in conjunction with FOR ALL ENTRIES.
or
This command contains additions (such as expressions or new SQL syntax) that cannot be used with FOR ALL ENTRIES.
Host variables are used in the select list of the affected SELECT FOR ALL ENTRIES statement.
Example:
The syntax error may only happen on 745+ kernel, but doesn't happen on 742 kernel.
Read more...
Environment
Kernel Release >= 745.
Product
Keywords
OPEN SQL, FAE, SQL syntax, For all entries, syntax error , KBA , BC-ABA-LA , Syntax, Compiler, Runtime , BC-DB-DBI , DB Independent Database Interface , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.