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
- 4221 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 could one combine a set of incremental image copies into a single copy?
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
how to identify the pseudo conversation by seeing the program
What is the significance of DB2 free space and what parameters control it?
what is difference between Static call and Dynamic call? How does it function?
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
what happend with out using Commit,when closing cursor and program?
What does sqlcabc has?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
Define db2.
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is bind and rebind in db2?
COBOL 
