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 meant by db2 predicate

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

New User


Joined: 12 Jun 2005
Posts: 12
Location: bangalore

PostPosted: Wed Nov 16, 2005 12:06 pm    Post subject: What is meant by db2 predicate
Reply with quote

what is meant by db2 predicate
Back to top
View user's profile Send private message

sathish_rathinam

New User


Joined: 22 Aug 2005
Posts: 59
Location: india

PostPosted: Wed Nov 16, 2005 1:49 pm    Post subject:
Reply with quote

hi ,

predicate is an element of search condition which implies a comparision operation..

cheers,
sathish
Back to top
View user's profile Send private message
Kavitha Palani

New User


Joined: 16 Nov 2005
Posts: 8

PostPosted: Tue Nov 22, 2005 4:12 pm    Post subject: Predicate
Reply with quote

A predicate is an element of a search condition that expresses or implies a comparison operation
Back to top
View user's profile Send private message
senthilssg

New User


Joined: 09 Dec 2005
Posts: 64
Location: USA

PostPosted: Fri Dec 09, 2005 3:32 pm    Post subject:
Reply with quote

Hi,

there is a two predicates are available..
primary predicate and secondary predicate
primary predicate is done in data manager and secondary predicate is done in relational data system (RDS).
so we should write query such that most of the process should be taken at the data manager by primary predicate ..

eg; if u use IN and BETWEEN are evolved in datamanager . ie no of records selected from the system for execution is limited in the first step itself .

In secondary predicate , out of selected rows from the data manager filter process ie colums which are wanted are taken out and dispalyed..


eg: all the simple select are secondary predicate



Regards,
Senthil kumar.k
chennai
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 Testing rerad cursor for status with ... John F Dutcher DB2 8 Fri May 19, 2017 9:35 pm
No new posts Using IN predicate in a SQL stored pr... gylbharat DB2 3 Tue Sep 11, 2012 10:56 am
No new posts What is meant by UNIT=DPERM? Prakash J JCL & VSAM 7 Thu May 24, 2012 9:06 am
No new posts What is meant by Wtr in SDSF? gnaveenkumar.99 All Other Mainframe Topics 1 Tue Jan 24, 2012 9:40 pm
No new posts What is meant by SLOC count? gnaveenkumar.99 All Other Mainframe Topics 7 Wed Dec 21, 2011 2:14 pm


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