Response

The rollback response is returned as a generic <ns2:sdsResult> response. This response returns the results of rolling back (aborting) a database transaction. The rollback request causes the transaction to end regardless of whether any updates were actually made to the database.

Note: The affected row count in the SOAP response is always 0. The affected row count does not indicate how many rows were modified within the transaction.

If the response error code indicates success, then the database transaction was successfully aborted. If any failure response is returned, then the database rollback failed.

Response Format

The response is displayed between the <soapenv:Body> and </soapenv:Body> XML tags, as shown in SOAP Response Messages.

<ns2:sdsResult affected="affected" error="error" [description="description"]>
</ns2:sdsResult>

Response Parameters

The parameters for all of the response commands are shown in SOAP Response Messages.

Response Error Codes

Table 1 lists common error codes for the rollback response. See SDS Response Message Error Codes for a complete list of error codes.

<rollback> Response Error Codes (SOAP)
Error Code	Description
SUCCESS	Transaction was successfully rolled back.
NO_ACTIVE_TXN	A read or write transaction is already open on this connection or an open transaction was aborted prior to terminating the connection.