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
- 7187 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 meaning of -805 SQL return code?
What's The Error Code For Unique Index Voilation?
Describe the elements of the SELECT query syntax?
How to fetch the uncommited data from table ?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
What information is held in SYSIBM.SYSCOPY?
Explain various types of locks in db2?
What do you mean by commit and rollback?
How connect db2 database to datastage?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
Explain db2.
COBOL 
