IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Static and Dynamic Calls with DB2 Programs


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
RahulChaudhari

New User


Joined: 03 Nov 2010
Posts: 11
Location: India

PostPosted: Sun Nov 30, 2014 1:37 am
Reply with quote

PGM-A is a DB2-COBOL program calling PGM-B which is simple Cobol program. PGM-B calls PGM-C which is again a COBOL-DB2 program. now PGM-C calls final routine PGM-D which is COBOL-DB2 program.

Could you please let me know if i require to have package for PGM-B?
Can i have single Plan containing all the packages? what will happen when i will change one of the DB2 PGM and a new DBRM is created for that? Do i need to rebind all the PGM packages? PLAN??

I have attached one excel sheet along with this post. Could you please look into that and reply to me?
Thanks for your help.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Sun Nov 30, 2014 3:33 am
Reply with quote

wiser not to post attachments, not everybody can download and see them,
also attaching document in MS proprietary format reduces furthermore the number of people who can look at them.

a plain text cut and paste ( using the code tags to preserve spacing ) is more than enough!
Back to top
View user's profile Send private message
RahulChaudhari

New User


Joined: 03 Nov 2010
Posts: 11
Location: India

PostPosted: Sun Nov 30, 2014 9:29 pm
Reply with quote

Can anyone help me??
Thanks in advance.

Rahul.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Sun Nov 30, 2014 10:16 pm
Reply with quote

please do not solicit for answers

it' s a weekend, and usually on weekends people will not care about work problems icon_cool.gif
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania

PostPosted: Mon Dec 01, 2014 11:13 pm
Reply with quote

I did not look at your attachment, as I am not allowed to download.

Here are the answers to your questions:

Quote:
Could you please let me know if i require to have package for PGM-B?

No it is not required, because it is not possible. There is no SQL, therefore no DBRM, therefore no package is possible.

Quote:
Can i have single Plan containing all the packages?

Yes, you want one plan for all the packages. You execute this plan calling Program-A

Quote:
what will happen when i will change one of the DB2 PGM and a new DBRM is created for that? Do i need to rebind all the PGM packages?

No, only the package for the changed program needs to be bound. This is assuming that your calls are dynamic.

PLAN??
No, the plan would not need to be bound again.
Back to top
View user's profile Send private message
RahulChaudhari

New User


Joined: 03 Nov 2010
Posts: 11
Location: India

PostPosted: Sat Dec 06, 2014 1:32 pm
Reply with quote

Thank you for your reply.
can you tell me if PGM-A is just a plain Cobol program and PGM-B is Cobol-DB2 , PGM-A calling PGM-B then do i need to create a package for PGM-A?
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 765
Location: Whitby, ON, Canada

PostPosted: Sat Dec 06, 2014 9:23 pm
Reply with quote

See daveporcelan's answer: "No it is not required, because it is not possible. There is no SQL, therefore no DBRM, therefore no package is possible. "

But you still need a Plan for PGM-A. The situation you describe is not unusual or rare.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts COBOL ZOS Web Enablement Toolkit HTTP... COBOL Programming 0
No new posts Using Dynamic file handler in the Fil... COBOL Programming 2
No new posts Fetch data from programs execute (dat... DB2 3
No new posts Passing Parameters to Programs Invoke... PL/I & Assembler 5
No new posts JCL Dynamic System Symbols JCL & VSAM 3
Search our Forums:

Back to Top