EXIT Statement [Interactive SQL]

Leaves Interactive SQL.

Syntax

{ EXIT | QUIT | BYE } [ return-code ]

return-code: number | connection-variable

Examples

– Set the Interactive SQL return value to 1 if there are any rows in table T, or to 0 if T contains no rows.
CREATE VARIABLE rowCount INT; CREATE VARIABLE retcode INT; SELECT COUNT(*) INTO rowCount FROM T; IF( rowCount > 0 ) THEN SET retcode = 1; ELSE SET retcode = 0; END IF; EXIT retcode;

Note: You cannot write the following the statement, because EXIT is an Interactive SQL statement (not a SQL statement), and you cannot include any Interactive SQL statement in other SQL block statements:
CREATE VARIABLE rowCount INT; SELECT COUNT(*) INTO rowCount FROM T; IF( rowCount > 0 ) THEN EXIT 1; // <-- not allowed ELSE EXIT 0; // <-- not allowed END IF;

Usage
Closes the Interactive SQL window, if you are running Interactive SQL as a windowed program, or terminates Interactive SQL altogether when run in command-prompt (batch) mode. In both cases, the database connection is also closed. 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.

The optional return code 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.

Side Effects

Automatically performs a commit, if option COMMIT_ON_EXIT is set to ON (the default); otherwise this statement performs an implicit rollback.

On Windows operating systems, the optional return value is available as ERRORLEVEL.

Standards
SQL—Vendor extension to ISO/ANSI SQL grammar.

Sybase—Not applicable by Adaptive Server Enterprise.

Permissions
None