Response

The <commitResp> response returns the results of committing a database transaction. If the response error code indicates success, then the update was successfully committed in the database. If any failure response is returned, then the database commit failed. The <commit> request causes the transaction to end regardless of whether any updates were actually made to the database.

Note:

The affected row count in the XML response will always be 0. It does not indicate how many rows were modified within the transaction.

Response Format

lengthInBytes
<commitResp [id="id"]>
[
    originalXMLRequest
]
    <res error="error" affected="affected" [description="description"]/>
</commitResp>

Response Parameters

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

Error Codes

Table 5-7 lists the common error codes for the <commitResp> response. See SDS Response Message Error Codes for a complete list of error codes.

Table 5-7 <commitResp> Error Codes (XML)

Return Code	Description
SUCCESS	Database transaction was committed successfully.
NO_ACTIVE_TXN	A transaction is not currently open on this connection.