|
I am not sure if SQLExecDirect has its own internal statement length limit,
why it would have it or what it would be, but here is the list of i5/OS SQL
statement length limits on different versions of the OS:
V5R1 Longest SQL statement 32,767
V5R2 Longest SQL statement 65,535
V5R3 Longest SQL statement 65,535
V5R4 Longest SQL statement (in bytes) 2 097 152 (2MB)
I personally would follow published system limits as i5/OS usually updates
all of their components to comply with new limits as new OSes are released.
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.
midrange.com
