Response

The commit response is returned as a generic <ns2:sdsResult> response. This response returns the result of the request to commit a database transaction.

If the response error code indicates success, then the database transaction was successfully committed in the database. If any failure response is returned, then the database commit failed. The commit operation 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. It does not indicate how many rows were modified within the transaction.

Response Format

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

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

Parameters

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

Error Codes

Table 9-7 shows common error codes for the <commitResponse> message. See SDS Response Message Error Codes for a full list of error codes.

Table 9-7 <commitResponse> Error Codes (SOAP)

Error Code	Description
SUCCESS	Transaction was successfully committed.
NO_ACTIVE_TXN	A read or write transaction is not currently open for this connection.