ASA Database Administration Guide
  Database Options
    Alphabetical list of options

COMMIT_ON_EXIT option [ISQL]

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; otherwise a ROLLBACK is done.