![command_delimiter option [Interactive SQL]](gif/backward.gif)
SQL Anywhere® Server - Database Administration
> SQL Anywhere Administration Tools
> Interactive SQL
> Interactive SQL options
commit_on_exit option [Interactive SQL]
Function
Controls behavior when Interactive SQL disconnects or terminates.
Allowed values
On, Off
Default
On
Description
Controls whether a COMMIT or ROLLBACK is done when you leave Interactive SQL. When commit_on_exit is set to On, a COMMIT is done.
See also