When you compile a program that accesses a CA Datacom SQL dataview, the default plan is generated automatically. If any plans already exist for the program, they are deleted. Deleted plans are listed in the compilation listing. After the existing plans are deleted, the default plan is regenerated for the program.
Note: No matter how many plans existed for a program, only one plan, the default plan, exists for that program after it is recompiled. If you require alternate plans for the program, you must define those plans again yourself.
If a program has several alternate plans or if an alternate plan has many plan options that differ from the default plan, you might want to create a member containing all of the commands required to generate the alternate plans for that program. You can execute this member after the program is recompiled. This protects you from inadvertently leaving out one of the required plan definitions after recompiling the program.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|