10 pts.
 Retreiving AS/400 SQL scripts
When I start sql on our iSeries, the system returns my previous scripts I have run. Which fle do these live in in the iSeries and can I report on them?

Software/Hardware used:
i570
ASKED: August 14, 2009  2:33 PM
UPDATED: October 12, 2009  3:09 PM

Answer Wiki:
Hi, I can't say the file name but to print your actual session (scripts used) just press F13 and choose option 2 or 4 to save the session content. Regards, Wilson The file name is the one that shows up when you do option 4 that Wilson indicates above. I believe the first time you run the STRSQL command it creates a default file for the device session. Gary ======================================================== The previous SQL statements (and result messages) are not stored in a file. They are stored in internal space objects associated with your user profile. Interactive SQL will dump the history to a file if you request it, as noted above. (You can type any file name you want.) The history is not only kept by user profile; it is further separated by device name. If you sign on concurrently to two devices and enter STRSQL, you'll quickly see the difference. However, this separation only happens when you first try to run STRSQL concurrently under two different devices. As long as you stick with STRSQL on one device at a time, you should continue to see full history regardless of device. (Once you cause the separation, there's no way to get it integrated again.) Tom
Last Wiki Answer Submitted:  October 11, 2009  12:12 pm  by  hafwhit   1,145 pts.
All Answer Wiki Contributors:  hafwhit   1,145 pts. , WilsonAlano   2,385 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Hi
this SQL scripts were saved in QSQLSESS file in QGPL library.

 465 pts.

 

Tom,

It’s very interesting!

Wilson

 2,385 pts.