SQL/MP Programming Manual for C

SQL/MP Statements and Directives
HP NonStop SQL/MP Programming Manual for C—429847-008
3-6
Finding Information
Data Status Language (DSL) Statements
GET CATALOG OF SYSTEM SQLRM Returns the name of a local or remote
system catalog.
GET VERSION SQLRM
SQLPM/C
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
SQLPM/C
Returns the program catalog version
(PCV), program format version (PFV), or
host object SQL version (HOSV) of an SQL
program file.
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.
Dynamic SQL Statements
DESCRIBE SQLRM
SQLPM/C
Returns information about output variables
for a prepared statement.
DESCRIBE INPUT SQLRM
SQLPM/C
Returns information about input variables
for a prepared statement.
EXECUTE SQLRM
SQLPM/C
Runs a prepared SQL statement.
EXECUTE IMMEDIATE SQLRM
SQLPM/C
Runs an SQL statement contained in a host
variable.
PREPARE SQLRM
SQLPM/C
Compiles a DDL, DML, DCL, or DSL
statement.
RELEASE SQLRM Deallocates memory for a dynamic SQL
statement referred to through a host
variable.
Table 3-1. Summary of SQL/MP Statements and Directives (page 4 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