Start transaction
Starts a transaction with the transaction options specified in the transaction parameter buffer.
Client
Int32
—p_operation
-
Operation code (
op_transaction
—29
) Int32
—p_sttr_database
-
Unused, always use
0
Buffer
—p_sttr_tpb
-
Transaction parameter buffer
Server
[wireprotocol-responses-generic] — on success, p_resp_object
is the new transaction handle.
The SET TRANSACTION
statement
Instead of using op_transaction
to start a transaction, it is also possible to use the SET TRANSACTION
statement.
This statement needs to be executed with execute immediate (op_execute_immediate
) without transaction.On success, the p_resp_object
holds the transaction handle.
Deviations for protocol version 11
Request flushing and response processing can be deferred.
If ptype_batch_send
or higher is used, other transaction operations can be sent immediately after starting the transaction.They can use the invalid object handle (0xFFFF
) instead of the — not yet received — transaction handle.This probably only makes sense for [wireprotocol-transactions-info].