Terminating a statement
These functions terminate a statement:
-
SQLFreeStmt
Provides these options for starting over:
odbc SQLFreeStmt $hstmt SQL_DROP odbc SQLFreeStmt $hstmt SQL_RESET_PARAMS odbc SQLFreeStmt $hstmt SQL_UNBIND
-
SQLFreeHandle
Frees resources that are associated with a statement handle.
odbc SQLFreeHandle SQL_HANDLE_STMT $hstmt
-
SQLCancel
Cancels processing on a statement handle.
odbc SQLCancel $hstmt
-
SQLEndTran
Attempts to roll back all active operations on all statements that are associated with the given connection:
odbc SQLEndTran SQL_HANDLE_DBC $hdbc SQL_ROLLBACK
This attempts to commit transactions on all connection handles associated with the given environment:
odbc SQLEndTran SQL_HANDLE_ENV $henv SQL_COMMIT