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
- 8132 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 |
What parameters are used to control the free space in DB2?
What is the syntax required for the creation of a cursor?
What is check constraint. Explain with example.
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
Name the different types of Table spaces.
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
What is cobol db2?
When do you specify the isolation level?
How to create a table using embedded sql?
what is Runstats? Whem will u choose to runatats?
How do you Load a table ?? and what is Load replace ?
How do I connect my db2 database to ibm?
COBOL 
