Interested to Buy Any Domain ? << Click Here >> for more details...
One program calling 5 subprograms, its a cobol db2 program,
after precompilation how many plans and packages will
created?
- 3 Answers
- 18312 Views
- I also Faced
- E-Mail Answers
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 |
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
What will the FREE command do to a plan?
What is runstats and reorg in db2?
What technique is used to retrieve data from more than one table in a single SQL statement?
how to unload different table data into different gdg files/ vsam files.
What is deadlock in db2?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
What is the use of commit in db2?
Define sqlca.
in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
What is the picture clause of the null indicator variable?
COBOL 
