Roll Back EDRS Server (QxdaRollbackEDRS) API
Required Parameter Group:
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(*) |
Service Program: QXDAEDRS
Default Public Authority: *USE
Threadsafe: Conditional; see Usage Notes
The Roll Back EDRS Server (QxdaRollbackEDRS) API is used to roll back transactions on the database server.
Authorities and Locks
None.
Required Parameter Group
- Connection handle
- INPUT; BINARY(4)
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.
- Additional rollback options
- INPUT; BINARY(4)
The following are valid rollback options:
0 QXDA_ROLLBACK_WORK 1 QXDA_ROLLBACK_WITH_HOLD
- SQL communications area
- OUTPUT; CHAR(136)
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.
- Error code
- I/O; CHAR(*)
The structure in which to return error information. For the format of the structure, see Error code parameter.
Usage Notes
This function may be called from the initial thread of a job only.
Error Messages
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. |
API introduced: V4R4
[ Back to top | Database and File APIs | APIs by category ]