RE: SQL Statement size limit?

Are you going through the ODBC/JDBC host server (QZDASOINIT)?

If so, do you have an exit program on the QIBM_QZDA_SQL2 exit point? Could it be truncating your SQL statement?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Thursday, April 18, 2013 7:41 AM
To: Midrange Systems Technical Discussion
Subject: SQL Statement size limit?

All,

Does anybody know what the SQL statement size limit for the iSeries is at
v5r4?

I found this:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzaik/exitpointtable1.htm

which shows a max statement size of 32K

But this
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/db2/rbafzmstlimtabs.htm

says
Maximum length of an SQL statement (in bytes) 2 097 152

Bit of a difference between 32KB and 2MB :)

Lastly, does the JDBC have some other limit?

Thanks!
Charles