SQL/MP Programming Manual for COBOL

SQL/MP Statements and Directives
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
3-6
Finding Information
Data Control Language (DCL) Statements
FREE RESOURCES SQLRM Closes cursors and releases locks held
by the program.
LOCK TABLE SQLRM Locks a table or underlying tables of a
view and associated indexes.
UNLOCK TABLE SQLRM Releases locks held on nonaudited
tables and views.
Data Status Language (DSL) Statements
GET CATALOG OF SYSTEM SQLRM Returns the name of a local or remote
system catalog.
GET VERSION SQLRM,
COBPM
Returns the version of a catalog,
collation, index, table, or view; also
returns the version of the SQL/MP
system software.
GET VERSION OF PROGRAM SQLRM,
COBPM
Returns the program catalog version
(PCV), program format version (PFV), or
host object SQL version (HOSV) of an
SQL program file.
Dynamic SQL Statements
DESCRIBE SQLRM,
COBPM
Returns information about output
variables in prepared statements.
DESCRIBE INPUT SQLRM,
COBPM
Returns information about input
variables in prepared statements.
EXECUTE SQLRM,
COBPM
Executes a prepared statement.
EXECUTE IMMEDIATE SQLRM,
COBPM
Executes an SQL statement contained in
a host variable.
PREPARE SQLRM,
COBPM
Compiles a DDL, DML, DCL, or DSL
statement.
RELEASE SQLRM Deallocates memory for a dynamic SQL
statement referred to through a host
variable.
Error-Checking Directive
WHENEVER SQLRM,
COBPM
Generates code that checks SQL
statement execution for errors, warnings,
and the not found condition for rows.
Table 3-1. NonStop SQL/MP Statements and Directives (page 4 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