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 db2 command?

0 Answers  

---

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

---

What is phantom read in db2?

0 Answers  

---

What is the syntax for creating a table in the db2 database?

0 Answers  

---

What is meant by concurrency?

1 Answers  

---

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

0 Answers   Infosys,

---

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers   IBM,

---

What do you need to do before you do EXPLAIN?

1 Answers  

---

What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,

---

How to take backup of table in db2?

0 Answers  

---

How to find the number of rows in a db2 table?

0 Answers  

---

wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,

---