if one db2 pgm calls another db2 pgm.
how many plans do we need.
what r the steps involved..
Answers were Sorted based on User's Feedback
Answer / guest
Only one plan is bound for this program with 2 DBRMS : one
for the main program and one for the called program. The
steps involved in preparing the program is 1. Precompile
produces modified source code and DBRM 2. compile the
modified source code 3.Link-edit the resulting module to
create the load module 4.Binding the plan
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / harish poomgame shivappa
Hi buddy,
one plan is reqired,,create 2 dbrms for two programs
steps
precompile with dsnhcob2
ikjeft01
create dbrm, then in next step using same ikjeft01 create
plan with this 2 dbrrm
pls let me know if u have any queries
HARISH POOMGAME SHIVAPPA
NIIT TECHNOLOGY
KOLKATA
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / abhay thakur
mr.harish i am not understandig for ur ans,plz send me ur number i want speak with you
| Is This Answer Correct ? | 0 Yes | 0 No |
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
where can we use index and subscript ? with example ?
How do I copy a table in db2?
Mention the different locking levels that are available in db2.
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
What do you mean by NOT NULL? When will you use it?
Explain the EXPLAIN statement?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
What is release/acquire in bind?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
What do you mean by rollback?