Question & Answer
Question
How to resolve SQL Code -516 and/or -514 issued on the client side?
Cause
The system messages manual indicates a -514 can be issued when the cursor is not in a prepared state. A -516 can be issued when the DESCRIBE statement does not identify a PREPARED statement. If those are not the case, those errors might due to the MAX ROWS EXAMINED/RETURNED limits have been reached.
Answer
Increase parameter MAX ROWS EXAMINED/RETURNED in the WIICF configuration file.
[{"Product":{"code":"SSDP9S","label":"InfoSphere Classic Federation Server for z\/OS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"General issues","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"9.1;9.5","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21222763