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?
Answers were Sorted based on User's Feedback
Answer / srikant
Package needs to be created for B only. Because we need to
bind those programs where we use any SQL statement. And
there only we need package...
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / pawan
First thing need to know is whenever we compile any module
only package gets created for particular module. And more
than 1 package can be bounded to single Plan. Here package
will be created for pgm b only and need to bind it to plan
thats it.
| Is This Answer Correct ? | 4 Yes | 0 No |
What r the comman abends in db2, jcl and cobol???????
What is QUIESCE?
What is sqlcode -922 ?
What is the meaning concurrency in the db2 database?
What is the difference between base table and view?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is db2 command?
What is dbrm? When it will be created?
what is the sqlcode -501
What is FREEPAGE and PCTFREE in TABLESPACE creation?
How does one remove entries from the SCT02 table?
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,