Exiting interactive SQL

 

To exit the interactive SQL environment, press F3 (Exit) on the Enter SQL Statements display. Several options are available for exiting.

• Save and exit session. Leave interactive SQL. Your current session will be saved and used the next time you start interactive SQL.

• Exit without saving session. Leave interactive SQL without saving your session.

• Resume session. Remain in interactive SQL and return to the Enter SQL Statements display. The current session parameters remain in effect.

• Save session in source file. Save the current session in a source file. The Change Source File display is shown to allow you to select where to save the session. You cannot recover and work with this session again in interactive SQL.

Notes:

1. Option 4 allows you to embed prototype SQL statements in a high-level language (HLL) program that uses SQL. Use the source entry utility (SEU) to copy the statements into your program. The source file can also be edited and used as the input source file for the Run SQL Statements (RUNSQLSTM) command.

2. If rows have been changed and locks are currently being held for this unit of work and you attempt to exit interactive SQL, a warning message is displayed.

 

Parent topic:

Using interactive SQL