Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SQL advanced material needed

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
donevin

New User


Joined: 07 Jun 2005
Posts: 70
Location: South Africa

PostPosted: Mon Nov 23, 2009 7:11 pm    Post subject: SQL advanced material needed
Reply with quote

Hi

I'm sure someone in the forum will be able to help. I'm looking for a manual or any means that will take me beyond normal sql. I want to see what happens when an SQL command is resolved. I want to know what gets executed first, how, when and where does the sort takes place if necessary.

I want to see step by step what happens when an SQL query, from the simplest one-liner to the most complex query with triple joins, subqueries, unions and whatever else you might throw in there gets executed. I want to get down and dirty with SQL for DB2 on a z/OS mainframe. Can anyone please point me in the right direction. You just have to point, that's all. I'll do all the legwork required.
Back to top
View user's profile Send private message

PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2442
Location: Netherlands, Amstelveen

PostPosted: Mon Nov 23, 2009 7:14 pm    Post subject:
Reply with quote

Try the SAS site.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Nov 23, 2009 9:11 pm    Post subject:
Reply with quote

Try (...if I understood the question correctly):
1. Visual Explain for DB2 for z/OS.
2. Explain tools
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Mon Nov 23, 2009 9:56 pm    Post subject:
Reply with quote

IBM Redbooks Just Published
Back to top
View user's profile Send private message
donevin

New User


Joined: 07 Jun 2005
Posts: 70
Location: South Africa

PostPosted: Tue Nov 24, 2009 11:34 am    Post subject:
Reply with quote

Thanks very much guys for your speedy replies. I will go through all the materials you suggested. Much appreciated.
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: Tue Nov 24, 2009 9:04 pm    Post subject:
Reply with quote

Hello,

If you can find some "db2 tuning" material, you should find some of what you are looking for.
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. SORT trick needed bshkris SYNCSORT 6 Tue May 02, 2017 4:35 am
No new posts Help Needed with View Direct shailesh_do CA Products 2 Wed Jul 13, 2016 10:39 am
No new posts Information needed on using the COBAN... venugopal.dondla COBOL Programming 5 Thu Oct 08, 2015 3:34 pm
No new posts Help needed in Conditional statement ... vinu78 DB2 5 Tue Sep 15, 2015 10:14 am
No new posts Easytrieve Report: Advanced blank Lin... Raj Vatsav CA Products 6 Mon Jul 06, 2015 2:59 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us