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 |
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Plan has the optimized access path in it. But is that optimized access path is attained or known
How to view db2 table structure?
List out the three types of page locks that can be held.
can any one give the list of some important sql abend codes which r frequently asked in interviews?
For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?
What is db2 catalog database?
How do I delete a table in database?
When reorg is used?
Is db2 a mainframe database?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.