what is a plan and how do you refer the plan in the
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|
Where besides the DB2 catalog is database object information stored by DB2?
What is the connection string to connect to the DB2 Database ?
When is the access path determined for dynamic SQL?
What do you mean by commit and rollback?
if i made sme changes in sub pgm wht r the things to be done for this ?
How would you print the output of an SQL statement from SPUFI?
What is the max length of sqlca?
What is alias in db2?
Normalization in DB2 – first normal form, second normal form
What is load replace in db2?
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?
What do you do to keep the cursor from closing after a commit?