What is the maximum size of SQL Query

wattamwar · New User Joined: 05 Mar 2008 Posts: 2 Location: Mumbai

what is the maximum size of SQL Query ??
a.32k
b.64k
c.56k
d.16k

sushanth bobby · Posted: Wed Dec 03, 2008 5:50 pm

In DB2 V8, The statement length can be 2M.
I have completely no-idea what it means.

I have completely no-idea how this is calculated. I think, type a query in notepad and see if the size is 2MB, if it is try to run it. I never seen a query that big.

By the way, what version you refering toooo.....

I hope iam correct,
Sushanth

wattamwar · New User Joined: 05 Mar 2008 Posts: 2 Location: Mumbai

hi Shshanth,

Thanks a lot....

We r using version 7.1..

dick scherrer · Posted: Mon Dec 08, 2008 12:58 pm

Hello,

This link provides Limits in DB2 - V7:
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnsqh11/A.0?

I do not see a limit that looks like what your question asks.

Also, i believe the question needs to be better asked - maybe by providing the definition of what is considered the size of a query for this question. As this is/was an interview question, it may be difficult to get clarification that would help here.

Suresh Ponnusamy · Posted: Mon Dec 08, 2008 8:49 pm

Hi

From the link which dick provided I could see the below one.