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
- 4258 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 to copy the host variables from ps file into cobol program other than include statement
What is db2 optimizer?
What is database alias db2?
How to solve S0C7 abend with out using DISPlay in 10 mins?
What is temporal table in db2?
explain about index with examples
Describe major components of db2?
What is meant by index cardinality?
How do you select a row using indexes in db2?
What is a Resource Control Table(RCT)? Describe its characteristics.
can any one give the list of some important sql abend codes which r frequently asked in interviews?
Which component is used to execute the sql statements?
COBOL 
