One program calling 5 subprograms, its a cobol db2 program,
after precompilation how many plans and packages will
created?
Answers were Sorted based on User's Feedback
Answer / sarath
when u precompile a Db2 program you will get (n+1) DBRMs
where n indicates no. of subprograms. So in our case you
will get 6 DBRMs. Through Binding process you can get
minimum of 1 package and maximum of 6 packages. But finally
you will get only one plan.
| Is This Answer Correct ? | 27 Yes | 2 No |
Answer / vat
Not trying to be cute, but, to the question "after
precompilation how many plans and packages will
created?" the answer would be zero.
You would have to do bind to even talk about packages/plans.
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / snehasis
If it generate 6 DBRM, then there is no possibility to have
1 package. The reason is one package can contain only one
DBRM. But yes for all these DBRM and Packages it will be
only one plan.
| Is This Answer Correct ? | 9 Yes | 3 No |
What does db2 blu stand for?
How do you prepare a COBOL + DB2 program from coading till execution ?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is host variable in db2 cobol?
How does a cursor work?
Is it possible using max on a char column?
How to find the number of rows in a db2 table?
insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
What is dbrm?
What types of tables are there in the db2 database?
What is a DB2 catalog?