Performing SQL Administrative Tasks › Rebinding a Plan

Rebinding a Plan

The Interactive SQL Service Facility allows you to specify plan options when rebinding an existing plan that was created as a result of SQL statements embedded in a program. The plan options you can specify during the Interactive SQL Service Facility session are slightly different from those you can specify before submitting a program with embedded SQL statements. See Coding Plan Options.

A change to an SQL table definition marks any plans referencing that table for a rebind. CA Datacom/DB attempts an automatic rebind of the plan when the program executes. If the rebind fails, you must make any necessary changes to your program and submit it to the SQL Preprocessor.

The REBIND PLAN option allows you to manually control the rebind instead of waiting for the automatic rebind attempt. A manual rebind:

• Saves execution time resources.
• Identifies source program changes necessary before the next scheduled execution of that program.
• Allows you to change the plan options.
• Could prevent abnormal termination of the program.

The REBIND PLAN option allows you to update a plan that may have become invalid but is assumed to be successfully rebound without the need for precompiling and linking the program again.