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
 

 

Static and Dynamic Calls with DB2 Programs

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Static and Dynamic Calls with DB2 Programs
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Sun Nov 30, 2014 3:33 am    Post subject: Reply to: Static and Dynamic Calls with DB2 Programs
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    Post subject:
Reply with quote

Can anyone help me??
Thanks in advance.

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

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Sun Nov 30, 2014 10:16 pm    Post subject: Reply to: Static and Dynamic Calls with DB2 Programs
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: 645
Location: Pennsylvania

PostPosted: Mon Dec 01, 2014 11:13 pm    Post subject:
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    Post subject:
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: 641
Location: Whitby, ON, Canada

PostPosted: Sat Dec 06, 2014 9:23 pm    Post subject:
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    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 Cobol list of programs being called biswajit.dattagupta COBOL Programming 5 Tue Nov 01, 2016 2:10 am
No new posts Can sending 5 MB data between cobol p... Kevin Vaz CICS 12 Tue Oct 18, 2016 4:50 pm
No new posts User exit in COBOL programs ganasrinivasan PL/I & Assembler 0 Thu Aug 18, 2016 12:48 pm
No new posts "DFSRRC00 vs IKJEFT01" for ... arunsoods All Other Mainframe Topics 5 Fri Aug 12, 2016 9:54 pm
No new posts Creating a dynamic sort card in JCL u... ChitraChhabra DFSORT/ICETOOL 4 Wed Aug 03, 2016 6:15 pm


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