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.
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.