Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8265 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 |
Explain dclgen.
What type of database is db2?
How many Buffer pools are there in DB2 and what are they?
How to execute stored procedure in db2 command editor?
What is dpf in db2?
What is UNION,UNION ALL?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What are the various isolation levels possible?
What is CHECK PENDING ?
When is the results table for the query in a DECLARE CURSOR statement created?
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
What is the FREE command?
COBOL 
