SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-76
Statements
ROLLBACK WORK Statement Undoes all database modifications made to audited
objects during the current TMF transaction and releases
all locks held by the transaction
SELECT Statement
Retrieves data from tables and views
SQL Directive
Indicates to a host language compiler that a program
contains SQL statements
UNLOCK TABLE Statement
Releases locks held on nonaudited tables or views
UPDATE Statement
Updates values in columns of a table or view
UPDATE STATISTICS
Statement
Updates statistics about the contents of a table and its
indexes
WHENEVER DIRECTIVE
* Specifies action to take when errors, warnings, or no-
row-found conditions occur in a program
Table S-3. Summary of SQL Statements
Command Action
* Can be used only in program