SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-3
Data Manipulation Language (DML) Statements
Data Manipulation Language (DML) Statements
Use these DML statements to delete, insert, select, or update rows in one or more
tables:
For information about DELETE, INSERT, SELECT, and UPDATE, see individual entries
for these statements.
Transaction Control Statements
Use these statements to specify user-defined transactions and to set attributes for the
next transaction:.
Prepared SQL Statements
Use these statements to compile an SQL statement and then execute the statement
any number of times within the current session:
REVOKE EXECUTE Statement on
page 2-173
Revokes access privileges for a procedure to
specified users.
SET Statement
on page 2-211 Controls the action of a BEFORE trigger.
SIGNAL SQLSTATE Statement
on
page 2-227
Enables a trigger execution to raise an exception that
causes both the triggered and triggering statements
to fail.
DELETE Statement
on page 2-110 Deletes rows from a table or view.
INSERT Statement
on page 2-149 Inserts data into tables and views.
SELECT Statement
on page 2-178 Retrieves data from tables and views.
UPDATE Statement
on page 2-231 Updates values in columns of a table or view.
BEGIN WORK Statement
on
page 2-27
Starts a transaction.
COMMIT WORK Statement
on
page 2-32
Commits changes made during a transaction and
ends the transaction.
ROLLBACK WORK Statement
on
page 2-176
Undoes changes made during a transaction and
ends the transaction.
SET TRANSACTION Statement
on
page 2-223
Sets attributes for the next SQL transaction—the
isolation level, access mode, size of the diagnostics
area, and whether to automatically commit database
changes.
EXECUTE Statement
on page 2-134 Executes an SQL statement previously compiled by
the PREPARE statement.
PREPARE Statement
on page 2-163 Compiles an SQL statement for later execution with
EXECUTE.