SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-218
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.
transaction mode
is an option that can be set in a SET TRANSACTION statement. You cannot
specify any of the options—isolation level, access mode, size of the diagnostics
area, or autocommit—more than once within one SET TRANSACTION statement.
You cannot use the AUTOCOMMIT option in combination with any other option.
SET TRANSACTION transaction-mode [,transaction-mode]...
transaction-mode is:
isolation-level
| access-mode
| diagnostics-size
| autocommit-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}
C/COBOL
C/COBOL