iSeries Navigator SQL Script Output
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.
Software/Hardware used:
Software/Hardware used:
ASKED:
August 12, 2010 4:46 PM
UPDATED:
August 20, 2010 12:53 PM
Answer Wiki:
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
To see all answers submitted to the Answer Wiki: View Answer History.
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.
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!
on next version of iSeries Navigator…
Keep in mind that the “next version” is V7R2 or perhaps V8R1.
Tom
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.”