SQL/MP Programming Manual for C

SQL/MP Statements and Directives
HP NonStop SQL/MP Programming Manual for C—429847-008
3-5
Finding Information
Data Manipulation Language (DML) Statements
CLOSE SQLRM
SQLPM/C
Terminates a cursor.
DECLARE CURSOR SQLRM
SQLPM/C
Defines a cursor.
DELETE SQLRM
SQLPM/C
Deletes rows from a table or view.
FETCH SQLRM
SQLPM/C
Retrieves a row from a cursor.
INSERT SQLRM
SQLPM/C
Inserts rows into a table or view.
OPEN SQLRM
SQLPM/C
Opens a cursor.
SELECT SQLRM
SQLPM/C
Retrieves data from tables and views.
UPDATE SQLRM
SQLPM/C
Updates values in columns of a table or
view.
Data Control Language (DCL) Statements
CONTROL EXECUTOR SQLRM
SQLPM/C
Specifies whether to process data using a
single executor or multiple executors
working in parallel.
CONTROL QUERY SQLRM
SQLPM/C
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
SQLPM/C
Specifies parameters that control locks,
opens, buffers, access paths, join methods,
and join sequences on tables and views.
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.
Table 3-1. Summary of SQL/MP Statements and Directives (page 3 of 4)
Statement or Directive Manual * Description
*This statement is documented in one or more of these manuals:
SQLRM SQL/MP Reference Manual
SQLPM/C SQL/MP Programming Manual for C