Limits to statement size in ISERIES

[--CELKO--]

We just got a "SQL Statement too long or complex" error on the
ISERIES. James was able to get a compile after replacing some full
table names with (much shorter) correlation names, etc.

I have not see his query, but what are the statement size limits? I
thought they would be so large that this should not happen in a
practical situation.

[Serge Rielau]

Re: Limits to statement size in ISERIES

--CELKO-- wrote:

We just got a "SQL Statement too long or complex" error on the
ISERIES. James was able to get a compile after replacing some full
table names with (much shorter) correlation names, etc.
>
I have not see his query, but what are the statement size limits? I
thought they would be so large that this should not happen in a
practical situation.

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

2MB for the past couple of releases.



--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[Karl Hanson]

Re: Limits to statement size in ISERIES

--CELKO-- wrote:

We just got a "SQL Statement too long or complex" error on the
ISERIES. James was able to get a compile after replacing some full
table names with (much shorter) correlation names, etc.
>
I have not see his query, but what are the statement size limits? I
thought they would be so large that this should not happen in a
practical situation.

In v5r4:
Maximum length of an SQL statement (in bytes) 2 097 152
(from:)

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/db2/rbafzmstlimtabs.htm

Prior to that:
Longest SQL statement 65535
(from:)

http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/db2/rbafzmstlimtabs.htm

--
Karl Hanson