CA Datacom/DB SQL Preprocessors › Using Preprocessor Options › Overview

Overview

The Preprocessor is controlled by options which you can specify before submitting a program with embedded SQL.

The values you assign to the options determine how the Preprocessor processes the SQL statements and control certain aspects of the application's environment.

The options you specify build the CA Datacom/DB access plan for your program containing embedded SQL. Every program with embedded SQL must have a plan, which is unique to that program. The plan contains:

• Information required by CA Datacom/DB about your program.
• Each embedded SQL statement in your program.

If you modify any SQL statement in your program, you must precompile your program again to update the plan.

Note: The Preprocessor options you specify in your host program have no effect on SQL statements submitted through CA Dataquery or the CA Datacom Datadictionary Interactive SQL Service Facility.