Recovering an SQL session

 

If the previous SQL session ended abnormally, interactive SQL presents the Recover SQL Session display at the start of the next session when you enter the Start SQL Interactive Session (STRSQL) command.

From this display, you can choose to do either of the following two things.

• Recover the old session by selecting option 1 (Attempt to resume existing SQL session).

• Delete the old session and start a new session by selecting option 2 (Delete existing SQL session and start a new session).

If you choose to delete the old session and continue with the new session, the parameters you specified when you entered STRSQL are used. If you choose to recover the old session, or are entering a previously saved session, the parameters you specified when you entered STRSQL are ignored and the parameters from the old session are used. A message is returned to indicate which parameters were changed from the specified value to the old session value.

 

Parent topic:

Using interactive SQL