EXIT statement [Interactive SQL]
520
EXIT statement [Interactive SQL]
Use this statement to leave Interactive SQL.
EXIT | QUIT | BYE
None.
This statement automatically performs a commit if option
COMMIT_ON_EXIT is set to ON (the default); otherwise it performs a
rollback.
"SET OPTION statement" on page 612
This statement closes your connection with the database, then closes the
Interactive SQL environment. Before closing the database connection,
Interactive SQL automatically executes a COMMIT statement if the
COMMIT_ON_EXIT option is set to ON. If this option is set to OFF,
Interactive SQL instead performs a ROLLBACK. By default, the
COMMIT_ON_EXIT option is set to ON.
♦
SQL/92 Vendor extension
♦
Sybase Not applicable in Adaptive Server Enterprise.
Function
Syntax
Permissions
Side effects
See also
Description
Standards and
compatibility