×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Need help on SQL RPGLE issue.
SQL0101 - SQL statement too long or complex
Error reason code : 5
5 - The total length of the statement text is greater than 2097152, or the
total length of the prepared attribute string text is greater than 65535.
Issue Background:
The SQL statement has 45,000 bytes and I am using CLOB data type(With size
as 100,000) for SQL but it still fails during the preparation statement of
SQL with error as SQL1010 - reason code 5.
This is JSON data sent to an external system using HTTPPUTCLOBVERBOSE.
Regards,
Mohan.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
