SQL
SQL affects whether the Db2® coprocessor is enabled and whether Db2 options can be specified.
- Default
- SQL=NO
- YES
- Use to enable the Db2 coprocessor and to specify Db2 options. You must specify the SQL option if your COBOL source program contains SQL statements and it has not been processed by the Db2 precompiler.
- NO
- Specify to have any SQL statements found in the source program
diagnosed and discarded.
Use SQL=NO if your COBOL source programs do not contain SQL statements, or if the separate SQL precompiler will be used to process SQL statements before invocation of the COBOL compiler.
Note:
You can specify the SQL option in any of the compiler option sources: compiler invocation, PROCESS or CBL statements, OPTFILE, or installation defaults.
- Use either quotation marks or apostrophes to delimit the string of Db2 options.
- Db2 options cannot be specified as part of customizing the SQL option. (Db2 options are supported only if the SQL compiler option is specified as an invocation option or in a CBL or PROCESS statement.) However, default Db2 options can be specified when you customize the Db2 product installation defaults.
