|
View previous topic :: View next topic
|
| Author |
Message |
RahulChaudhari
New User
Joined: 03 Nov 2010
Posts: 11
Location: India
|
|
|
|
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 |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10886
Location: italy
|
|
|
|
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 |
|
|
RahulChaudhari
New User
Joined: 03 Nov 2010
Posts: 11
Location: India
|
|
|
|
Can anyone help me??
Thanks in advance.
Rahul. |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10886
Location: italy
|
|
|
|
please do not solicit for answers
it' s a weekend, and usually on weekends people will not care about work problems  |
|
| Back to top |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania
|
|
|
|
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 |
|
|
RahulChaudhari
New User
Joined: 03 Nov 2010
Posts: 11
Location: India
|
|
|
|
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 |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010
Posts: 765
Location: Whitby, ON, Canada
|
|
|
|
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 |
|
|
|
|
