When you are ready to move a program that accesses a CA Datacom SQL dataview into the production environment, you might want to change some of the plan options. You can do this without recompiling the program by entering the ALTER PROGRAM ENVIRONMENT command. You can then rebind the plan with the REBIND command to change the default plan.
If you want to be able to select a different plan dynamically at runtime, you need to create the alternate plan with the DEFINE AUTHORIZATION command. You can then enter the ALTER PROGRAM ENVIRONMENT command to change the plan options the program uses and enter the REBIND command with the new authorization ID to rebind the new plan.
To select the plan at runtime, use the ASSIGN AUTH command before running the program.
The following sections explain each of these commands.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|