Options for SQL statement processing

Use SQL processing options to specify how the DB2® precompiler and the DB2 coprocessor interpret and process input, and how they present output.

If you are using the DB2 precompiler, specify SQL processing options in one of the following ways:

With DSNH operands
With the PARM.PC option of the EXEC JCL statement
On DB2I panels

If you are using the DB2 coprocessor, specify SQL processing options in one of the following ways:

For C or C++, specify the options as the argument of the SQL compiler option.
For COBOL, specify the options as the argument of the SQL compiler option.
For PL/I, specify the options as the argument of the PP(SQL('option,...')) compiler option.

For examples of how to specify the DB2 coprocessor options, see Processing SQL statements by using the DB2 coprocessor

DB2 assigns default values for any SQL processing options for which you do not explicitly specify a value. Those defaults are the values that are specified on the APPLICATION PROGRAMMING DEFAULTS installation panels.