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
 
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 Inserting records based on conditions vickey_dw DFSORT/ICETOOL 9 Wed Feb 22, 2017 1:33 pm
No new posts Need help in building a logic Benchwarmer All Other Mainframe Topics 4 Wed Feb 22, 2017 2:49 am
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

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