User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To leave ISQL.

Syntax

     EXIT| QUIT| BYE

Usage

ISQL.

Permissions

None.

Side effects

Will do a commit if option COMMIT_ON_EXIT is ON (default); otherwise will do a rollback.

See also

• SET OPTION statement

Description

Leave the ISQL environment and return to the operating system. This will close your connection with the database. Before doing so, ISQL will perform a COMMIT operation if the COMMIT_ON_EXIT option is ON. If the option is OFF, ISQL will perform a ROLLBACK. The default action is to COMMIT any changes you have made to the database.