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 |
i want to delete 20th million record how ?
If I have a view which is a join of two or more tables, can this view be updatable?
What is dbrm library?
wht displays the number of times a query modified ?
How to handle null values in db2
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
How does db2 sample database connect?
Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?
Where would you find information about the type of database authority held by the user?
What is a Database Request Module(DBRM)?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
Explain packages.