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
Related Q&A from Ken Graap
Find out if log files can be omitted during a save without causing problems in a full restore. Continue Reading
The BRMS Network feature allows a BRMS system to connect to other BRMS systems via a network, and enables a user to consolidate media such as backup ... Continue Reading
The only option to correct damage preventing file journaling is to use the RCLSTG command. Continue Reading