DBISQL provides two options that let you control when and how transactions end:
If you set the option AUTO_COMMIT to ON, DBISQL automatically commits your results following every successful statement, and automatically performs a ROLLBACK after each failed statement.
The setting of the option COMMIT_ON_EXIT controls what happens to uncommitted changes when you exit DBISQL. If this option is set to ON (the default), DBISQL does a COMMIT; otherwise it undoes your uncommitted changes with a ROLLBACK statement.
Sybase IQ also supports Transact-SQL commands, such as BEGIN TRANSACTION, for compatibility with Adaptive Server Enterprise. IQ allows you to explicitly start a transaction using the BEGIN TRANSACTION command. For further information, see Appendix A, “Compatibility with Other Sybase Databases,” in the Sybase IQ Reference Manual.
