SQL/MP Programming Manual for COBOL

SQL/MP Statements and Directives
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
3-3
Finding Information
Data Division
You can use these statements and directives in the Data Division:

BEGIN DECLARE SECTION and END DECLARE SECTION directives

DECLARE CURSOR statement

INVOKE directive

INCLUDE STRUCTURES directive

INCLUDE SQLCA, INCLUDE SQLDA, and INCLUDE SQLSA directives

INCLUDE SQLCODEX directive
Procedure Division
You can use these statements and directives in the Procedure Division:

Data Control Language (DCL) statements

Data Definition Language (DDL) statements

Data Manipulation Language (DML) statements (including DECLARE CURSOR)

Data Status Language (DSL) statements

Dynamic SQL statements

WHENEVER directive
Anywhere in the Program
You can use the CONTROL directive anywhere in a program.
Finding Information
Table 3-1 summarizes the SQL/MP statements and directives you can embed in a
COBOL program and shows where each statement or directive is documented.
Table 3-1. NonStop SQL/MP Statements and Directives (page 1 of 5)
Statement or Directive Manual* Description
Data Declaration Directives
BEGIN DECLARE SECTION SQLRM,
COBPM
Designates the beginning of host
variable declarations.
END DECLARE SECTION SQLRM,
COBPM
Designates the end of host variable
declarations.
INCLUDE STRUCTURES SQLRM,
COBPM
Specifies the version of SQL structures
generated.
INCLUDE SQLCA SQLRM,
COBPM
Generates the SQLCA structure for run-
time status and error information.
* This statement is documented in one or more of these manuals:
SQLRM
SQL/MP Reference Manual
COBPM SQL/MP Programming Manual for COBOL