Full text search
function	SQLEndTran

Library: ODBC Include: omodbc.xin

Returns: Numeric An SQL return code. The following values may be returned: SQL_SUCCESS (the commit or rollback was performed). SQL_SUCCESS_WITH_INFO (the commit or rollback was performed, but a message was issued). SQL_ERROR (an error occurred). SQL_INVALID_HANDLE (the handle is invalid).

Declaration

  define external counter function SQLEndTran
     (  value counter HandleType,
        read-only SQL_handle_type Handle,
        value counter CompletionType )

Requests a commit or rollback operation for all active operations on all statements associated with a connection. The SQLEndTran function can also request that a commit or rollback operation be performed for all connections associated with an environment.

Input arguments:

1. HandleType. The handle type identifier. The following values are allowed:
   • SQL_HANDLE_ENV
   • SQL_HANDLE_DBC
2. Handle. The handle indicating the scope of the transaction.
3. CompletionType. The following values are allowed:
   • SQL_COMMIT
   • SQL_ROLLBACK