Every program that accesses CA Datacom/DB using embedded SQL or FOR constructs must have an access plan that is unique to that program. CA Ideal builds the plan for the application and binds each SQL statement as part of program compilation. The authorization ID and other plan options are taken from the program environment fill‑in (described in the Creating Programs Guide).
You can change the plan options and rebind a plan without recompiling the program by using the ALTER PROGRAM ENVIRONMENT command, followed by the REBIND command. You can also define alternate plans for a program and select the appropriate plan at runtime. For more information about defining and maintaining alternate plans, see the Administration Guide.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|