Need Help: SQL statement too long or complex -- MIDRANGE-L

Subject: Need Help: SQL statement too long or complex
From: mohanraj <mohanskcet@xxxxxxxxx>
Date: Thu, 13 May 2021 21:01:42 +0530
List-archive: <https://archive.midrange.com/midrange-l/>
List-post: <mailto:midrange-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=unsubscribe>

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.

Follow-Ups:

RE: Need Help: SQL statement too long or complex , Birgitta Hauser

This mailing list archive is Copyright 1997-2026 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.