Retreiving AS/400 SQL scripts
10 pts.
0
Q:
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: Aug 14 2009  2:33 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
7990 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
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 Answered: Oct 11 2009  12:12 AM GMT by TomLiotta   7990 pts.
Latest Contributors: Hafwhit   630 pts., WilsonAlano   2005 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Chenthil   250 pts.  |   Aug 25 2009  3:19PM GMT

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

 

WilsonAlano   2005 pts.  |   Oct 12 2009  3:09PM GMT

Tom,

It’s very interesting!

Wilson

 
0