Previous Topic: Defining the Environment for SQL AccessNext Topic: Primary Database


CA Datacom SQL Access Plan Options

CA Ideal uses the CA Datacom SQL access plan options to build the CA Datacom/DB access plan for the program during program compilation. These plan options are described in the CA Datacom/DB Database SQL User Guide.

For mixed sites, the CA Datacom/DB access plan options do not affect DB2 application plans.

The plan options are specified on the environment definition fill-in. You can use the SET DBSQL command to specify default values for the fill-in.

To display or edit the plan options, select option 1 from the Program Maintenance menu. Fill in field 1 and field 2 as appropriate. Specify env for field 3 and press the Enter key. The plan options fill-in displays.