SQL

SQL affects whether the Db2® coprocessor is enabled and whether Db2 options can be specified.

Syntax

Read syntax diagramSkip visual syntax diagramSQL=*NOYES
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:
  • Start of changeYou can specify the SQL option in any of the compiler option sources: compiler invocation, PROCESS or CBL statements, OPTFILE, or installation defaults.End of change
  • 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.

Start of change

related tasks  
Compiling with the SQL option (Enterprise COBOL Programming Guide)
End of change