Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


what is a plan and how do you refer the plan in the
program?

Answers were Sorted based on User's Feedback



what is a plan and how do you refer the plan in the program?..

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

what is a plan and how do you refer the plan in the program?..

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

Post New Answer

More DB2 Interview Questions

Where besides the DB2 catalog is database object information stored by DB2?

1 Answers  


What is the connection string to connect to the DB2 Database ?

0 Answers   MCN Solutions,


When is the access path determined for dynamic SQL?

2 Answers  


What do you mean by commit and rollback?

0 Answers  


if i made sme changes in sub pgm wht r the things to be done for this ?

1 Answers   TCS,






How would you print the output of an SQL statement from SPUFI?

2 Answers  


What is the max length of sqlca?

0 Answers  


What is alias in db2?

0 Answers  


Normalization in DB2 – first normal form, second normal form

4 Answers   Virtusa,


What is load replace in db2?

0 Answers  


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?

2 Answers  


What do you do to keep the cursor from closing after a commit?

1 Answers  






Categories