Getting Started › DBSQLPR › Processing

Processing

The execution flow for DBSQLPR is as follows:

1. DBSQLPR examines any input parameters passed programmatically or through the command line (the PARM= specification in the JCL). See DBSQLPR Options.
2. The options file is opened and processed. With the exception of the OPTFILE= parameter, which may only appear on the PARM= input parameter string, any option may appear in either the options file or the PARM= specification. Those specified on the PARM= input parameter string override any duplicate specification in the options file.

   Note: The same set of plan options you can specify in the COBOL Preprocessor can be specified in DBSQLPR. See Specifying Processing Options in COBOL.

3. The SYSIN file is read, and the input is processed as a series of commands (see Line Commands) and SQL statements.