SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—544517-008
2-240
SET TRANSACTION Statement
/* Set timeout value for ORDERS table from host variable */
EXEC SQL SET TABLE orders TIMEOUT hv_timeout;
SET TRANSACTION Statement
Considerations for SET TRANSACTION
MXCI Examples of SET TRANSACTION
C Examples of SET TRANSACTION
COBOL Examples of SET TRANSACTION
The SET TRANSACTION statement is used to set attributes for the next transaction
(and only the next transaction). The attributes are the isolation level, access mode,
size of the diagnostics area, and whether to automatically commit changes made to the
database. The isolation level and the access mode affect the degree of concurrency
available for transactions.
SET TRANSACTION transaction-mode [,transaction-mode]...
transaction-mode is:
isolation-level
| access-mode
| diagnostics-size
| autocommit-option
| autobegin-option
isolation-level is:
ISOLATION LEVEL access-option
access-option is:
READ UNCOMMITTED
| READ COMMITTED
| SERIALIZABLE
| REPEATABLE READ
access-mode is:
READ ONLY | READ WRITE
diagnostics-size is:
DIAGNOSTICS SIZE number-of-conditions
autocommit-option is:
AUTOCOMMIT {ON | OFF}
autobegin-option is:
AUTOBEGIN {ON | OFF}
C/COBO
L
C/COBO
L