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
On which levels locks can be applied?
Mention some fields that are a part of sqlca.
How to check table size in db2 sap?
What are concurrency issues?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
How does a cursor work?
Is db2 a programming language?
How to execute stored procedure in db2 command editor?
What is the information associated with sysibm.syslinks table?
can all users have the privilage to use the sql statement select * (dml)?
How do I add a column in db2?
How do I import data from excel to db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is sqlca?
What is alias in db2?