SQLTransact requests a commit or rollback operation for all active operations on all hstmts associated with a connection. SQLTransact can also request that a commit or rollback operation be performed for all connections associated with the henv.
The following table describes the SQLSTATE and error values for SQLTransact.
| SQLSTATE | Error Value | Error Message |
|---|---|---|
| 01000 | -11001 | General warning |
| 08003 | -11017 | Connection not open |
| S1000 | -11060 | General error |
| S1001 | -11061 | Memory-allocation failure |
| S1010 | -11067 | Function-sequence error |
| S1012 | -11069 | Invalid transaction operation code |
| S1C00 | -11092 | Driver not capable |
| 08S01 | -11301 | A protocol error has been detected. Current connection is closed. |