if one db2 pgm calls another db2 pgm.
how many plans do we need.
what r the steps involved..
Answer Posted / guest
Only one plan is bound for this program with 2 DBRMS : one
for the main program and one for the called program. The
steps involved in preparing the program is 1. Precompile
produces modified source code and DBRM 2. compile the
modified source code 3.Link-edit the resulting module to
create the load module 4.Binding the plan
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the difference between bind and rebind in db2?
Explain the contention situations caused by locks?
can we view the access paths created by dbrm ? how ? thx
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is reorg and runstats in db2?
What is db2 look?
What is sqlca?
What r the comman abends in db2, jcl and cobol???????
Explain the benefits you can get from mainframe connect?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is the maximum length of sqlca?
What is alias in db2?
How do I copy a table in db2?
What kind of database is db2?