SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
2-4
Transaction Control Statements
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
Use these statements to compile an SQL statement and then execute the statement
any number of times within the current session:
Embedded-Only SQL/MX Statements
For more information on SQL/MX statements that you can use only in embedded SQL
programs, see Section 3, Embedded-Only SQL/MX Statements
.
BEGIN WORK Statement on
page 2-43
Starts a transaction.
COMMIT WORK Statement
on
page 2-48
Commits changes made during a transaction and
ends the transaction.
ROLLBACK WORK Statement
on
page 2-240
Undoes changes made during a transaction and
ends the transaction.
SET TRANSACTION Statement
on
page 2-288
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-169 Executes an SQL statement previously compiled by
the PREPARE statement.
PREPARE Statement
on page 2-224 Compiles an SQL statement for later execution with
EXECUTE.