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