exit

Description

Leaves Interactive SQL.

Syntax

{exit | quit | bye} [{number | connection_variable}]

Parameters

exit | quit | bye

closes your connection with the database, then closes the Interactive SQL environment.

{number | connection_variable}

can be used in batch files to indicate success or failure of the commands in an Interactive SQL command file. The default return code is 0.

  • number – is the number of the return code.

  • connection_varible – is a variable indicating a specific connection.

Usage

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 performs an implicit rollback. By default, the commit_on_exit option is set to on.

Permissions

Any user can execute this command.