Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Regarding COBOL DB2 compilation PLAN

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
venkatamv

New User


Joined: 26 Nov 2004
Posts: 3

PostPosted: Fri Nov 26, 2004 9:57 pm    Post subject: Regarding COBOL DB2 compilation PLAN
Reply with quote

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? icon_razz.gif
Back to top
View user's profile Send private message

jz1b0c

Active User


Joined: 25 Jan 2004
Posts: 160
Location: Toronto, Canada

PostPosted: Sat Nov 27, 2004 4:00 am    Post subject:
Reply with quote

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
View user's profile Send private message
venkatamv

New User


Joined: 26 Nov 2004
Posts: 3

PostPosted: Mon Nov 29, 2004 8:00 pm    Post subject:
Reply with quote

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
View user's profile Send private message
venkatamv

New User


Joined: 26 Nov 2004
Posts: 3

PostPosted: Thu Dec 02, 2004 6:14 pm    Post subject: hi...
Reply with quote

Hi Masade,

Why u r idle, may i get the answer for my question from u.
Back to top
View user's profile Send private message
anuradha

Active User


Joined: 06 Jan 2004
Posts: 247
Location: Hyderabad

PostPosted: Thu Dec 02, 2004 9:00 pm    Post subject:
Reply with quote

Hi Venkat,

There is a wonderful article written by By Bonnie Baker in DB2 magazine about these plans,packages,collections,timestamp concept etc etc...

Just check the following links.It is given in 3 parts:

http://www.db2mag.com/story/showArticle.jhtml?articleID=15300107

http://www.db2mag.com/story/showArticle.jhtml?articleID=17602333

http://www.db2mag.com/story/showArticle.jhtml?articleID=18901299


Hope after going thru this article all your doubts will be cleared.
Back to top
View user's profile Send private message
jz1b0c

Active User


Joined: 25 Jan 2004
Posts: 160
Location: Toronto, Canada

PostPosted: Fri Dec 03, 2004 3:06 am    Post subject: Re: hi...
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Execute TSO ACF commands from COBOL-I... supreethi.srid TSO/ISPF 0 Tue Feb 21, 2017 5:19 pm
No new posts Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am
No new posts Mainframe Interview Questions CICS,CO... akshathan Mainframe Interview Questions 6 Thu Feb 09, 2017 6:38 pm
No new posts Submit job from Cobol with input data abdulrafi COBOL Programming 4 Wed Feb 01, 2017 12:41 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us