RE: new user for IFS

embed SQL to query SYSCOLUMNS in Excel, presto, near real-time pivot tables with table-column (file-field) info.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Tuesday, May 28, 2013 8:33 AM
To: Midrange Systems Technical Discussion
Subject: Re: new user for IFS

Buck,

I think he is trying to get a listing of columns in a table, and their properties, into Excel. Perhaps for documentation purposes. I think he is hoping to export the picture from iNav into Excel. If he just "has" to document this in Excel then I suggest querying SYSCOLUMNS instead. I am of the opinion that any report like this, whether it's on paper or in Excel, is obsolete the day it's created. And I fall back on SYSCOLUMNS or DSPFFD or alternative tools like DSPLYT.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Buck Calabro <kc2hiz@xxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx,
Date: 05/28/2013 10:00 AM
Subject: Re: new user for IFS
Sent by: midrange-l-bounces@xxxxxxxxxxxx



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