CA Datacom/DB SQL Preprocessors › Using Preprocessor Options › Specifying Processing Options in PL/I, C, and Assembler › Using the Source Method in PL/I, C, and Assembler

Using the Source Method in PL/I, C, and Assembler

Option specifications in the source can appear on any record but should not be combined with actual code, because the option specification is commented.

The marker $DBSQLOPT is used by the Preprocessor to recognize option specifications. In Assembler and C, start $DBSQLOPT in column 1. In PL/I, however, start $DBSQLOPT in column 2. In PL/I, C, or Assembler, the $DBSQLOPT marker must be followed by at least one blank before the option specifications begin. The marker may be followed by:

• In PL/I and C, one or more specifications separated by commas and terminated with a semicolon.
• In Assembler, one or more specifications separated by commas.

Options of the plan must be specified prior to the first SQL statement in the source because the plan is added at that point.