Interested to Buy Any Domain ? << Click Here >> for more details...
what is a plan and how do you refer the plan in the
program?
- 2 Answers
- 7303 Views
- Xansa, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / harsha
plan is executable.it contains access path.we will refer
plan in jcl as plan name.generally all information abt the
plan will be there in sysibm.sysplan
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / guest
The DBRM name is the program name and should be bound to a
plan before the DB2 program can be executed. The plan is
nothing but bound DBRMs or packages.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is the difference between primary key & unique index ?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
What is the difference between IN subselects and EXISTS subselect?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
what is sql abend code -801,-802?
How do you filter out the rows retrieved from a Db2 table ?
What is a cursor and what is its function?
What does CURRENTDATA option in bind indicate
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
What is the use of runstats in db2?
What does the RUNSTATS Utility do?
What is package in cobol db2?
COBOL 
