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

return-code : number | connection-variable

This statement closes the Interactive SQL window if you are running Interactive SQL as a windowed program, or terminates Interactive SQL altogether when running 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 checked in batch files to determine the success or failure of the statements in an Interactive SQL script file. The default return code is 0.

None.

This statement automatically performs a commit if option commit_on_exit is set to On (the default); otherwise it performs an implicit rollback.

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

• SET OPTION statement
• Interactive SQL

The following example sets 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;

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;