SQL preprocessor options

This section describes the options that the SQL preprocessor supports.

Two groups of options can be passed to the SQL preprocessor: those handled by the PL/I SQL preprocessor and those handled by the DB2® coprocessor. You must specify these options in the options string of the PP(SQL('option-list')) option, and the options can be intermingled in the options string.

When you specify SQL preprocessor options, the list of options must be enclosed in a pair of quotation marks. For example, to specify the CCSID0 option, you must specify PP(SQL('CCSID0')).

Table 1 lists the PL/I SQL preprocessor options with abbreviations (if any) and the IBM-supplied default values. This table uses a vertical bar (|) to separate mutually exclusive options, and brackets ([ ]) to indicate that you can sometimes omit the enclosed option.

For more information about Db2 coprocessor options, see the Db2 for z/OS Application Programming and SQL Guide.