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.