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?
- 3 Answers
- 8470 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 |
Answer / Kapil Kumar Vishnoi
During the compilation process, a plan and package will be created for both pgm A and pgm B since pgm A is calling pgm B. This is known as DB2's stored procedure concept where the called program (pgm B) becomes part of the calling program (pgm A)'s package.
| Is This Answer Correct ? | 0 Yes | 0 No |
Are view updateable?
What is a page?
What is schema in db2?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is db2 bind?
What is a LIKE table and how is it created?
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
What are leaf pages?
What is meant by dclgen?
Explain dclgen.
What is a page in db2?
Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.
COBOL 
