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 Need DB2 query to fetch previous row ! Chandan1993 DB2 10 Sat Jun 03, 2017 10:43 am
No new posts To find out size allocated to a seque... ashek15 JCL & VSAM 15 Thu Apr 27, 2017 9:42 am
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Omegamon for DB2 query ashek15 DB2 0 Wed Feb 15, 2017 11:25 am


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