Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

What is the maximum size of SQL Query

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
wattamwar

New User


Joined: 05 Mar 2008
Posts: 2
Location: Mumbai

PostPosted: Wed Dec 03, 2008 5:31 pm    Post subject: What is the maximum size of SQL Query
Reply with quote

what is the maximum size of SQL Query ??
a.32k
b.64k
c.56k
d.16k
Back to top
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Dec 03, 2008 5:50 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
wattamwar

New User


Joined: 05 Mar 2008
Posts: 2
Location: Mumbai

PostPosted: Mon Dec 08, 2008 12:31 pm    Post subject:
Reply with quote

hi Shshanth,

Thanks a lot....

We r using version 7.1..
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Dec 08, 2008 12:58 pm    Post subject:
Reply with quote

Hello,

This link provides Limits in DB2 - V7:
http://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.
Back to top
View user's profile Send private message
Suresh Ponnusamy

Active User


Joined: 22 Feb 2008
Posts: 107
Location: New York

PostPosted: Mon Dec 08, 2008 8:49 pm    Post subject:
Reply with quote

Hi

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

Code:


In Db2 7

Longest SQL statement             32765 bytes         
                     
 


So the answer will be around 32K.

Code:

In DB2 8
Longest SQL statement             2,097,152 bytes         



Please refer the below given link

http://www.informit.com/content/images/0672326132/downloads/appd.pdf
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Join in SQL Query vickey_dw DB2 2 Tue Jan 17, 2017 12:15 am
This topic is locked: you cannot edit posts or make replies. MQ setup query mohitsaini Java & MQSeries 4 Sun Jan 08, 2017 1:53 am
No new posts DB2 query Using Recursion, Converting... smilewithashu2 DB2 1 Tue Jan 03, 2017 12:50 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
This topic is locked: you cannot edit posts or make replies. Db2 SQL query to convert rows into co... subratarec DB2 5 Thu Nov 17, 2016 4:51 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us