CA Ideal Commands › ALTER PROGRAM ENVIRONMENT Command (CA Datacom SQL Access)

ALTER PROGRAM ENVIRONMENT Command (CA Datacom SQL Access)

The ALTER PROGRAM ENVIRONMENT command changes the CA Datacom access plan options for the specified program in the object code for the program without having to recompile the program. The options changed are permanently altered in the object program until a subsequent ALTER or a recompilation takes place. To apply these changes to the run‑time access plan, use the REBIND command. If you defined multiple plans for the program, you must rebind each plan where the altered plan options apply.

You can specify these options before compiling a program using the program environment fill‑in (except the CLOSE option). You can specify default values for the compile using the SET DBSQL command (except the WORK and CLOSE options).

Note: Do not perform this command for a program that was the object of a CREATE MODULE. Perform the ALTER PROGRAM before the CREATE MODULE if you need to alter the plan options. For more information, see the Administration Guide.

This command has the following format:

ALTER PROGRAM name [VERSION version] [ENVIRONMENT option]