Maintaining Plans for CA Datacom SQL Access › Maintaining Access Plans for the Run-Time Environment › Selecting an Alternate Plan at Runtime

Selecting an Alternate Plan at Runtime

If a program was defined with more than one plan, you can select the appropriate plan dynamically at runtime by entering the ASSIGN AUTH command before executing the program.

The format of the ASSIGN AUTH command is:

ASSIGN AUTH authid1 NEW authid2

• authid1-Authorization ID of the default plan.
• authid2-Authorization ID of the alternate plan. This authorization ID is sent with the program name, version, and system to identify the required plan when the SQLCA is passed to CA Datacom. As a result, the statements in the alternate plan execute instead of the statements in the default plan.

Note: The plan identified with the specified authorization ID must exist in the current dictionary for the program to run with that plan.