HP 3000 Manuals

Leaving ISQL [ ALLBASE/ISQL Reference Manual ] MPE/iX 5.0 Documentation


ALLBASE/ISQL Reference Manual

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. 



MPE/iX 5.0 Documentation