SQLTransact() - Transaction management

SQLTransact() is a deprecated function and is replaced by SQLEndTran().

ODBC specifications for SQLTransact()

Table 1. SQLTransact() specifications
ODBC specification level In X/Open CLI CAE specification? In ISO CLI specification?
1.0 (Deprecated) Yes Yes

Syntax

SQLRETURN   SQLTransact      (SQLHENV           henv,
                              SQLHDBC           hdbc,
                              SQLUSMALLINT      fType);

Function arguments

The following table lists the data type, use, and description for each argument in this function.

Table 2. SQLTransact() arguments
Data type Argument Use Description
SQLHENV henv input Environment handle.

If hdbc is a valid connection handle, henv is ignored.
SQLHDBC hdbc input Database connection handle.

If hdbc is set to SQL_NULL_HDBC, then henv must contain the environment handle that the connection is associated with.
SQLUSMALLINT fType input The action for the transaction. The value for this argument must be one of:
  • SQL_COMMIT
  • SQL_ROLLBACK