Get started Bring yourself up to speed with our introductory content.

Saving interactive SQL sessions

You can save your interactive SQL sessions and when you re-enter SQL on the same session for the same logon then previous statements are displayed. These must be stored somewhere on the 400, but my question is where. Can they be viewed via query, DSPPFM, or are they in the OS/400 somewhere and cannot be accessed?

It is iSeries smoke and mirrors...
Actually, when you save an SQL session for later use via option 1 the session is saved in a recovery object in library QRECOVERY.

This recovery object is an internal system object. It is not visible with a DSPLIB, and it is not accessible from a user program.

You can also use F3 option 4 or F13 option 4 to save the session to a source file.

Dig Deeper on iSeries SQL commands and statements

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.