When running a query in batch receive one of the two errors:
ERROR: 57011 Resource Limit Exceeded When input values are exceeded
The number of literals in the conditions is greater than the amount that Query can handle. The limit will vary, IBM limit for the number of literals allowed is 1024.
The number of literals in the conditions is greater than the amount that Query can handle.
This was to have been an enhancement to raise the limit from 1024 literals to 2048. Unfortunately IBM had a problem with this. As a workaround they suggested modifying the QAQQINI file to not send Parameter Markers. Each literal is considered a Parameter. IBM also sends a Parameter Marker when processing SQL requests. The Parameter Marker is not needed.
WRKOBJ *ALL/QAQQINI *ALL
UPDATE QSYS/QAQQINI SET QQVAL='*NO' WHERE QQPARM='PARAMETER_MARKER_CONVERSION'
Still have questions? We can help. Submit a case to Technical Support.