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
- 7077 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 |
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
What is load replace in db2?
How can you count the number of rows from a table tab?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
What is database reorganization?
What is the database descriptor?
Can we install 2 different versions of Db2 on same mainframe?
What is a cursor and what is its function?
Explain packages.
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
how do you resolve -805?
COBOL 
