× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



On 5/26/2013 9:36 AM, Crystal Reports wrote:

Terminology. What you are using is called Navigator for IBM i. Most
people here will understand you if you call it iNavigator or iSeries
Navigator or Navigator or iNav or something with 'Nav' in it. I myself
ignored this message because IFS means Integrated File System, which is
a place to store stream files, not a way to run SQL statements.
Specifically, the part of iNav you are using to run SQL scripts is
called 'Run SQL Scripts'.

I have been able to save the file info - I need fields and lengths, descriptions into an excel. I look under schemas, and get a grid of this info needed, but I dont see how to simply save all this into an excel.
it has an option for save, just save, but where does this go?

It goes where you saved it.
Right click.
Save results.
In this panel, the top box is 'File name:'. This points to a file on
your local hard drive - on your own PC, not on the IBM side.

If you can't see 'Save results' on a right click, close the results
window, click Options, then click 'Allow save results'. Re-run the
query and you can then save it.

and it does not let you simply copy and paste the entire thing.

When I click inside my results, then type Ctrl-A to select all, then
Ctrl-C to do a Windows Copy, I can paste my results into another document.

this may be basic question but is not intutitive at all.

Aside from having to tell iNav to 'Allow Save Results', it works like
most Windows programs do.
--buck

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.