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?
- 2 Answers
- 7422 Views
- I also Faced
- E-Mail Answers
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 |
How can you count the number of rows from a table tab?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What does runstats do in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?
What is db2 optimizer?
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is an intent lock?
What is deadlock in db2?
How to find schema of a table in db2?
What is the maximum length of sqlca?
COBOL 
