SQL/MP Programming Manual for COBOL

SQL/MP Statements and Directives
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
3-5
Finding Information
Data Definition Language (DDL) Statements
HELP TEXT SQLRM Specifies help text for a column of a
table or view.
UPDATE STATISTICS SQLRM Updates information about the contents
of a table and its indexes.
Data Manipulation Language (DML) Statements
CLOSE SQLRM,
COBPM
Terminates a cursor.
DECLARE CURSOR SQLRM,
COBPM
Defines a cursor.
DELETE SQLRM,
COBPM
Deletes rows from a table or view.
FETCH SQLRM,
COBPM
Retrieves a row from a cursor.
INSERT SQLRM,
COBPM
Inserts rows into a table or view.
OPEN SQLRM,
COBPM
Opens a cursor.
SELECT SQLRM,
COBPM
Retrieves data from tables and views.
UPDATE SQLRM,
COBPM
Updates values in columns of a table or
view.
Data Control Language (DCL) Statements
CONTROL EXECUTOR SQLRM,
COBPM
Specifies whether to process data using
a single executor or multiple executors
working in parallel.
CONTROL QUERY SQLRM,
COBPM
Specifies whether to optimize query time
for the first few rows or for all rows,
whether to consider a hash join
algorithm for executing queries, or
whether to use execution-time name
resolution.
CONTROL TABLE SQLRM,
COBPM
Specifies parameters that control locks,
opens, buffers, access paths, join
methods, and join sequences on tables
and views.
Table 3-1. NonStop SQL/MP Statements and Directives (page 3 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