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?
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.
