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

How to switch plans within a batch cobol program


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

New User


Joined: 05 Oct 2006
Posts: 1

PostPosted: Wed Dec 09, 2009 5:20 am
Reply with quote

I have a set of tables grouped by owner. Our bind procedure creates a plan for each group of tables by owner. So if I want to process group A, I execute the cobol program using the plan for group A. If I want to process the group B tables I execute the same cobol program using the plan for group B.

How can I dynamically select which plan to use in the cobol program so the program can decide which plan to use during the execution of the program and possibly switch between plans during the same execution of the program?
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1020
Location: India

PostPosted: Wed Dec 09, 2009 11:34 am
Reply with quote

Hi Gjdeluca,

Dynamically changing a plan inside a program, i dont know or i never seen somebody do it.

Quote:
Our bind procedure creates a plan for each group of tables by owner.

You can bind to different set of collections and these collection has to be in the same plan. Like one collection is called COLGRPA and the other one is called COLGRPB and these have to be bound to a plan PLNGRPS.

Quote:
If I want to process the group B tables I execute the same cobol program using the plan for group B

In your COBOL program, use
Code:
SET CURRENT PACKAGESET = :collection-name

to switch collection.

And ofcourse, you have to change the qualifier of both packages.

Thank You,
Sushanth
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 Replace each space in cobol string wi... COBOL Programming 3
No new posts Using API Gateway from CICS program CICS 0
No new posts COBOL -Linkage Section-Case Sensitive COBOL Programming 1
No new posts COBOL ZOS Web Enablement Toolkit HTTP... COBOL Programming 0
No new posts Calling DFSORT from Cobol, using OUTF... DFSORT/ICETOOL 5
Search our Forums:

Back to Top