what is a plan and how do you refer the plan in the
program?
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 |
how to fetch first 100 rows in db2
What is a DB2 plan?
is there any restrictions for unions ?
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
Which catalog tables contain authorization information?
What is the picture clause of the null indicator variable?
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
What is EXPLAIN?
Can you use max on a char column?
What is cursor?
what is the process of precompiler?
Explain about rct in db2?