| 1 | Connection handle | Input | Binary(4) |
| 2 | Additional rollback options | Input | Binary(4) |
| 3 | SQL communications area | Output | Char(136) |
| 4 | Error code | I/O | Char(*) |
The Roll Back EDRS Server (QxdaRollbackEDRS) API is used to roll back transactions on the database server.
None.
The handle number of the connection on which to perform the rollback operation. The connection handle must have been generated by the QxdaConnectEDRS API in the current job and activation group.
The following are valid rollback options:
| 0 | QXDA_ROLLBACK_WORK |
| 1 | QXDA_ROLLBACK_WITH_HOLD |
Returns diagnostic information. It includes the SQLCODE variable, indicating whether an error has occurred. If SQLCODE has a value of 0 after a call to this API, the function was successful.
The format of this structure is standard and is described more completely in the SQL programming and DB2® for IBM® i SQL reference topic collections.
The structure in which to return error information. For the format of the structure, see Error code parameter.
This function may be called from the initial thread of a job only.
| Message ID | Error Message Text |
|---|---|
| CPF180C E | Function &1 not allowed. |
| CPF24B4 E | Severe error while addressing parameter list. |
| CPF3C90 E | Literal value cannot be changed. |
| CPF9872 E | Program or service program &1 in library &2 ended. Reason code &3. |
| CPFB750 E | Connection handle specified not valid. |
| CPFB751 E | Parameter &1 passed not correct. |
| CPFB752 E | Internal error in &1 API. |
| CPFB757 E | The connection is suspended. |
| CPFB758 E | The EDRS server system has been switched. |
[ Back to top | Database and File APIs | APIs by category ]