SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-4
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 more information about DELETE, INSERT, SELECT, and UPDATE statement, 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
REVOKE SECURITY_ADMIN
Statement on page 2-325
Revokes security administration privileges from
designated users.
SET Statement
on page 2-364 Controls the action of a BEFORE trigger.
SIGNAL SQLSTATE Statement
on
page 2-380
Enables a trigger execution to raise an exception that
causes both the triggered and triggering statements
to fail.
DELETE Statement
on page 2-161 Deletes rows from a table or view.
INSERT Statement
on page 2-251 Inserts data into tables and views.
SELECT Statement
on page 2-329 Retrieves data from tables and views.
SELECT ROW COUNT Statement
on page 2-362
Retrieves the count of rows from the
SQL/MX table.
UPDATE Statement
on page 2-384 Updates values in columns of a table or view.
BEGIN WORK Statement
on
page 2-52
Starts a transaction.
COMMIT WORK Statement
on
page 2-57
Commits changes made during a transaction and
ends the transaction.
ROLLBACK WORK Statement
on
page 2-327
Undoes changes made during a transaction and
ends the transaction.
SET TRANSACTION Statement
on
page 2-375
Sets attributes for the next SQL transaction—the
isolation level, access mode, size of the diagnostics
area, and whether to automatically commit database
changes.