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
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our AS/400 experts
View all AS/400 questions and answers
Start the conversation
0 comments