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
This topic is locked: you cannot edit posts or make replies. Unavailable RECON datasets while exec... abdulrafi JCL & VSAM 10 Fri Apr 06, 2018 12:45 pm
No new posts IMS error U4038 while executing my PL... abdulrafi IMS DB/DC 2 Thu Feb 08, 2018 1:05 pm
No new posts SQLCODE 518 while executing DB2 module. abdulrafi DB2 8 Wed Feb 07, 2018 10:46 am
No new posts Logic to skip Maximum time-stamp and ... vickey_dw DB2 2 Thu Feb 01, 2018 11:15 pm
No new posts Is CICS BMS logic on z/OS different ... Andi1982 CICS 2 Fri Dec 01, 2017 1:56 pm

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