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

Can a Db2 table data be retrived through JCL?

4 Answers  

---

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  

---

where will u check for sqlcode ?

2 Answers   TCS,

---

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers   CTS,

---

What is collection in db2 bind?

0 Answers  

---

What is DCLGEN ?

2 Answers  

---

What are the advantages of using a PACKAGE?

2 Answers  

---

How do you select a row using indexes in db2?

0 Answers  

---

Can we update view in db2?

0 Answers  

---

What is the use of DELGEN in DB2? Can we Write the program with out using it?

6 Answers   Cap Gemini,

---

What is a db2 collection?

0 Answers  

---

What is buffrpool? Where we use it ?

2 Answers   Tesco,

---