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 sqlcode -811?

7 Answers   Accenture, CTS, TCS,

---

What is role in db2?

0 Answers  

---

What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,

---

what is utility for parm lib

0 Answers   IBM,

---

How do I change the column size in db2?

0 Answers  

---

In a DB2-CICS program which is acts as co-ordinator and which is participant?

1 Answers   IBM,

---

What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,

---

Update command

1 Answers  

---

What types of tables are there in the db2 database?

0 Answers  

---

Can one database have multiple instances?

0 Answers  

---

What is the physical storage length of the data types date, time, and timestamp?

0 Answers  

---

What is isolation level?

4 Answers  

---