Controls the behavior when Interactive SQL disconnects or shuts down.

Allowed values

On, Off

Default

On

Remarks

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

• SET OPTION statement [Interactive SQL]