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
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
IBM's iSeries Backup and Recovery manual answers many questions related to system backup and disaster recovery. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.