Interested to Buy Any Domain ? << Click Here >> for more details...
What is a PLAN table? How will you use it? Give the various
fields of PLAN table?
- 1 Answers
- 4335 Views
- Accenture, I also Faced
- E-Mail Answers
Answer / sneha
Plan is an access path for your program to access the DB2 table. During precompilation process, the SQL queries are converted into executable statements and stored in DBRM (Database Request Module). This DBRM will have a consistency token. During the bind step, this DBRM will be read and a plan will be produced. Few important parameters we include in Bind job is ISOLATION LEVEL ( how one transaction needs to be separated from another transaction which does some data modification on the table), QUALIFIER etc.
| Is This Answer Correct ? | 1 Yes | 0 No |
How do you stop a db2 database in linux?
What is Skeleton cursor table (SKCT)?
How to fetch the last row from the table in SQL (db2)?
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
How can we define a table? How can we apply SEARCH ALL on it ?
can i code union in cobol-db2 pgm ?
what are extents?
How to resolve -818 sql code in DB2?
Why db2 is called db2?
How will fetch last 5 rows from table in db2
How do I start db2 in windows?
What are bind parameters in db2?
COBOL 
