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
- 8373 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 |
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
What is db2 look?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
What is difference between isnull and coalesce?
what is difference between Plan and Package
Where are plans stored?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
can we update the table by using cursors can anyone post the query?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?
COBOL 
