Rolls back an indoubt transaction
(that is, a transaction that has been prepared).
If the
operation succeeds, the transaction's state becomes heuristically
rolled back.
Scope
This API only affects the node on
which it is issued.
Required connection
Database
API and data structure syntax
extern int SQL_API_FN sqlxphrl(
int exe_type,
SQLXA_XID *pTransId,
struct sqlca *pSqlca
);
sqlxphrl API parameters
- exe_type
- Input. If EXE_THIS_NODE is specified, the operation
is executed only at this node.
- pTransId
- Input. XA identifier of the transaction to be heuristically rolled
back.
- pSqlca
- Output. A pointer to the sqlca structure.
Usage notes
Only transactions with a status
of prepared or idle can be rolled back. Once heuristically rolled
back, the database manager remembers the state of the transaction
until the sqlxhfrg API is called.