|
View previous topic :: View next topic
|
| Author |
Message |
venkatamv
New User
Joined: 26 Nov 2004
Posts: 3
|
|
|
|
Hi...
I want to clarify some of the doubts regarding the PLAN.
If we Precompile any COBOL DB2 Program, If we are having 100 sql's also we will get only one DBRM, and if we BIND that DBRM we will get one Package, But PLAN is to point more PACKAGES, how it is possible, because after Precompilation of every step we will get only one DBRM, and according to that one PACKAGE, then how the Plan will point to more Pakcages concept will come here.
Can anybody clarify my doubt?  |
|
| Back to top |
|
 |
jz1b0c
Active User
Joined: 25 Jan 2004
Posts: 160
Location: Toronto, Canada
|
|
|
|
in you cobol program there are thousands of statements but still only one load module is created do you agree with this,
Now your program can call many number of sub programs, accept?.
Plan is a collection of packages. Plan authorizes you to access and packages give the access path. |
|
| Back to top |
|
|
venkatamv
New User
Joined: 26 Nov 2004
Posts: 3
|
|
|
|
Hi Friend,
Thanks for ur reply.
That means for each and every subprogram one DBRM will be created if it is having the sql's. Right?
And for all those DBRM's if we apply the BIND we will get multiple Packages & and the PLAN will point to all those Packages. Right?
If any wrong let me know.
I am having another doubt, how the Time Stamp concept will come in PLAN & Load Module. Can u explain me some what elaborately with any one Program which is having the Subprograms, that is with multiple Load modules & with multiple Packages.
Bye. |
|
| Back to top |
|
|
venkatamv
New User
Joined: 26 Nov 2004
Posts: 3
|
|
|
|
Hi Masade,
Why u r idle, may i get the answer for my question from u. |
|
| Back to top |
|
|
anuradha
Active User
Joined: 06 Jan 2004
Posts: 247
Location: Hyderabad
|
|
| Back to top |
|
|
jz1b0c
Active User
Joined: 25 Jan 2004
Posts: 160
Location: Toronto, Canada
|
|
|
|
| venkatamv wrote: |
Hi Masade,
Why u r idle, may i get the answer for my question from u. |
I am sorry man , I was off this week. |
|
| Back to top |
|
|
|
|
