Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is explain in db2?
What is rebind in db2?
How to test SQL -911 error while developing COB-DB2 program
What is the physical storage length of timestamp data type?
What is null indicator in db2?
What is the physical storage length of date data type?
Is db2 a mainframe?
How to find schema of a table in db2?
What do you mean by cursor?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What are the various isolation levels possible?
What is package in db2 mainframe?
What are db2 tables?
What is cursor stability in db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
