Leaving ISQL

To terminate an ISQL session, you use the END or the EXIT command as follows:

   isql=> END;

   

   $

If a DBEnvironment transaction is in progress when you submit the END or EXIT command, ISQL prompts you as follows:

   isql=> END;

   A transaction is in progress.  Commit work (Y/N)>

ISQL automatically terminates the transaction based on your response.

If you enter YES, ISQL issues a COMMIT WORK statement. When the COMMIT WORK statement is executed, changes to the database are made permanent. If you enter NO, ISQL issues a ROLLBACK WORK statement. When the ROLLBACK WORK statement is executed, changes to the database that have not been committed are undone. ISQL then automatically terminates your DBE session by processing a RELEASE statement.