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
 

 

Internal Logic of Executing the Conditions in DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Sasi Kiran Patha
Warnings : 2

New User


Joined: 19 Nov 2006
Posts: 73
Location: Hyederabad

PostPosted: Fri Jan 19, 2007 6:29 pm    Post subject: Internal Logic of Executing the Conditions in DB2
Reply with quote

Hi Guys,

Lets Consider the below Example

Select * from XYZ Table
Where (Cond 1) AND
(Cond 2) AND
(Cond 3) AND
(Cond 4)

Now in the above example lets suppose the execution of COND 1 resulted in the retrieval of Zero records from the table. In that case does the DB2 System Quit with out executing the rest of the Conditions (COND 2, COND 3, COND 4) as the first Condition got failed or it proceeds ahead and Checks for the remaining Conditions also (COND 2, COND 3, COND 4)

Thanks,
Sasi Patha
Back to top
View user's profile Send private message

DavidatK

Active Member


Joined: 22 Nov 2005
Posts: 700
Location: Troy, Michigan USA

PostPosted: Fri Jan 19, 2007 9:57 pm    Post subject: Re: Internal Logic of Executing the Conditions in DB2
Reply with quote

Sasi Patha,

Unfortunately, or fortunately, it?s not that simple. DB2 analyses your SQL and determines the best approach to satisfying you query. It?s not a top down execution.
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
No new posts Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
No new posts Easytrieve - Report writing - Only 1 ... Abhi Nature CA Products 2 Wed Sep 14, 2016 11:40 am
No new posts Wildcard logic in COBOL dudenithy COBOL Programming 13 Thu Sep 01, 2016 7:36 pm
No new posts Getting soc4 on internal table in cobol abdulrafi COBOL Programming 13 Fri May 06, 2016 3:39 pm


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