ROLLBACK is provided for syntactic compatibility only. COMMIT and ROLLBACK functionality is supported automatically by ISQL and ODBC. By default, both ISQL and ODBC automatically commit transactions at the end of every statement. This can be changed from ODBC only by making appropriate ODBC calls to initiate a manual transaction.
ROLLBACK [WORK]