iSeries Navigator SQL Script Output

60 pts.
Tags:
Ad Hoc
iSeries Navigator
SQL Query
SQL Scripting
I'm not familiar with CL but is there an easy way to direct the output of an adhoc SQL query in iSeries Navigator into a CSV file in my local Windows drive? Thanks in advance.
ASKED: August 12, 2010  4:46 PM
UPDATED: August 20, 2010  12:53 PM

Answer Wiki

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

In System i Access V6R1, a new option is available. The menu bar Options drop-down has item Allow Save Results. When checked, you can right-click the results panel and select Save Results… to save the result set as a .CSV, among other choices.

Prior to V6R1, I’d only expect to run CPYTOIMPF through Run SQL Scripts CL: function.

Tom

Discuss This Question: 4  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
  • BeanBaggs
    I think on next version of iSeries Navigator they are going to make this easy V6r1, not for sure but I thought I saw that somewhere. I don't think before that there is a easy way. Look at a freeware product called FROG for IBM i5.
    210 pointsBadges:
    report
  • Jaggerdude
    I've been using the Navigator for ad-hoc queries which couldn't be done using the Data Transfer facility. Didn't know that it could actually "Process SELECT as native SQL" in the Properties button before. Just fumbled into it so now I could take advantage of it's save to file options without having to know CL and waiting for company to upgrade to V6.... Thanks for the replies--much appreciated!
    60 pointsBadges:
    report
  • TomLiotta
    on next version of iSeries Navigator... Keep in mind that the "next version" is V7R2 or perhaps V8R1. Tom
    125,585 pointsBadges:
    report
  • Kprazor
    Another option - I sometimes go into Excel, click on Data, then transfer Data from iSeries. As you step through the process you can enter your SQL statements under Data Options. The process will run the SQL statements and load the data directly into the spreadsheet. Then you can do a "save as."
    45 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