SQL/MP Programming Manual for COBOL

SQL/MP Statements and Directives
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
3-7
Finding Information
Table 3-2 summarizes COBOL compiler directives that apply to a COBOL program
containing embedded SQL statements and directives. For a description of all other
COBOL compiler directives, see the COBOL85 for NonStop Systems Manual.
Transaction Control Statements
BEGIN WORK SQLRM Starts a TMF transaction.
COMMIT WORK SQLRM Commits all database changes made
during the current TMF transaction and
frees resources.
ROLLBACK WORK SQLRM Backs out the current TMF transaction
and frees resources.
Table 3-2. COBOL Compiler Directives for SQL/MP
Directive Manual * Description
SOURCE COBPM,
COBRM
Copies source code from a source file into the compilation.
SQL COBPM,
COBRM
Indicates to the HP COBOL compiler that a program contains
embedded SQL statements or directives.
Specifies options for processing the SQL statements or
directives:

PAGES specifies the number of 2048-byte pages that the
HP COBOL compiler allocates to the SQL compiler
interface (SCI).

SQLMAP generates an SQL map in the listing.

WHENEVERLIST writes active WHENEVER options to
the listing file after each SQL statement is processed.

RELEASE1 or RELEASE2 specifies the version of the
SQL/MP features in the program (including the SQL data
structures) and the version of SQL/MP software on which
the program can run.
SQLMEM COBPM,
COBRM
Controls the placement of SQL internal structures in either the
user data segment (Working-Storage Section) or extended
data segment (Extended-Storage Section).
* This statement is documented in one or more of these manuals:
SQLRM
SQL/MP Reference Manual
COBPM SQL/MP Programming Manual for COBOL
Table 3-1. NonStop SQL/MP Statements and Directives (page 5 of 5)
Statement or Directive Manual* Description
* This statement is documented in one or more of these manuals:
SQLRM
SQL/MP Reference Manual
COBPM SQL/MP Programming Manual for COBOL