RE: CTE's and SQL performance

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Here are SQL statement limit:

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 suspect you're hitting some snag with the tool and not the actual SQL
statement limit.

-----Original Message-----
Subject: RE: CTE's and SQL performance

My SQL statement does not contain 32,767 characters, more like 10,000
but I think strsql is counting all of the whitespace to the right of the
text.

-----Original Message-----
Subject: RE: CTE's and SQL performance

I can see in my question I did a bad job explaining the problem, the
performance problem happens after I add the inline views to the query,
but before I have joined them into the main select clause. Their
presence alone cause the problem, however by themselves they each run
for a couple of seconds and returns a single number. I suspect that I am
bumping up against some kind of DB2 size limit, perhaps too many
characters or too many inline views, which is making it change something
about the way it runs it. When I try to run the statement in STRSQL it
refuses on the grounds that " Length of statement exceeds 32,767
characters."