Reference Manual
   CHAPTER 9. SQL Statements     

EXIT statement [ISQL]

Function 

To leave Interactive SQL.

Syntax 

EXIT | QUIT | BYE

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 Interactive SQL environment and return to the operating system. This will close your connection with the database. Before doing so, Interactive SQL will perform a COMMIT operation if the COMMIT_ON_EXIT option is ON. If the option is OFF, Interactive SQL will perform a ROLLBACK. The default action is to COMMIT any changes you have made to the database.

Standards and compatibility 

• SQL/92     Vendor extension

• Sybase     Not applicable in Adaptive Server Enterprise.