Answer / yuvaevergreen

Indexable predicates are the one which match with index
entries. It depends on the indexes that are available and
the access path chosen at bind time.
For example,if the employee table has an index on the
column LASTNAME,
the following predicate can be a matching predicate:
SELECT * FROM emp WHERE LASTNAME = 'SMITH';
Stage 1 predicates are the predicates which are processed
by Data
manager component of DB2 as soon as it recieves data from
the buffer manager.
Some examples are:
COL BETWEEN value1 AND value2
COL IN (list)
COL LIKE host variable
more examples:
http://publib.boulder.ibm.com/cgi-bin/bookmgr/
BOOKS/dsnapj12/6.3.3.2?
DT=20050328013405#TBLISARG

What is copy pending status in db2?

0 Answers  

---

what is consistency token

3 Answers  

---

How to solve S0C7 abend with out using DISPlay in 10 mins?

1 Answers   IBM,

---

how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

1 Answers   UST,

---

What is a DB2 catalog?

2 Answers  

---

What is the use of predicate?

0 Answers  

---

What is the error code -803 ?

3 Answers  

---

If I have a view which is a join of two or more tables, can this view be updateable?

0 Answers  

---

What is universal database?

0 Answers  

---

is there any restrictions for unions ?

4 Answers   Patni,

---

What is the maximum size of a char data type in db2?

0 Answers  

---

What is sqlca’s maximum length?

0 Answers  

---