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?
Answer Posted / 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 |
Post New Answer View All Answers
what is a corelated subquerry?
Is ibm db2 open source?
Is schema the same as database?
How to find the maximum value in a column in the db2 database?
Mention the location where the output received from explain statement is stored.
Mention data types used in db2 ?
What is the difference between drop table and delete table?
How to fetch the last row from the table in SQL (db2)?
What is an instance in db2?
What is the use of predicate?
Explain the contents that are a part of dclgen.
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is blu acceleration in db2?
Explain what are the various isolation levels possible?
What is the use of db2 optimizer?