Retreiving AS/400 SQL scripts

10 pts.
Tags:
i570
iSeries SQL
SQL commands
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

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • chenthil
    Hi this SQL scripts were saved in QSQLSESS file in QGPL library.
    465 pointsBadges:
    report
  • WilsonAlano
    Tom, It's very interesting! Wilson
    2,435 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following