END

If you have a DBEnvironment transaction in progress when you issue the END command, ISQL prompts you as follows:

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

Enter N to roll back any DBEnvironment change(s) you made since signing on or since the latest COMMIT WORK. ISQL automatically processes a ROLLBACK WORK statement, and your changes are undone.

Enter Y to commit any DBEnvironment change(s) you made since signing on or since the latest COMMIT WORK. ISQL automatically processes a COMMIT WORK statement, and any of your changes become permanent.

After any transaction has ended, the DBE session is automatically terminated. ISQL then issues a RELEASE or STOP DBE statement on your behalf.

END has the same effect as EXIT.