RE: File Definitions

Maybe you are also aware  of this, but if you do your System Request option
(Shift, Esc on a pc) when on an AS/400 screen, then type option 3 Press
Enter, Option 14, all the files feeding that particular display will appear.
An F11 will change the display to enable you to see whether the source is
Logical, Physical, Dsp, etc.  This can also be helpful.

Bonnie Cameron
Polaris Industries



> -----Original Message-----
> From: McCready, Joan [SMTP:Joan.McCready@metaltekint.com]
> Sent: Friday, October 13, 2000 8:53 AM
> To:   'MAPICS-L@midrange.com'
> Subject:      RE: File Definitions
> 
> I have become a power IWP user (by necessity - I am forbidden by company
> policy to write RPG reports) and had the same questions that you do,
> George.
> I tried to use the MAPICS data dictionary, but was unable to get it to
> populate the files (do you need to have the source code on your machine to
> use this, BTW?).  I did a combination of things - went into OS/400 PDM,
> printed a list of the files in AMFLIB, and downloaded to an Excel
> spreadsheet.  I also create the file definition reports (CAS, Reports,
> File
> Layout), downloaded the print files to Word, cleaned them up and have my
> own
> "data book" - used DFU to get the keys for the logicals and noted them
> with
> the physical file layouts in the Word documents, etc.
> 
> The most frustrating part of this has been getting the relationships of
> the
> files correct, and figuring out where the fields are coming from.  ERL
> works
> for the COM and IFM file relationships, but not the "heart" of MAPICS,
> which
> is the IM/PDM/PCC/PUR relationships of ITEMASA/B/C.  The MAPICS help desk
> has also been willing to tell me, if I give them the MAPICS screen name,
> which files the fields displayed come from. (I get end users saying
> "here's
> the screen - I want a report showing me this data for all <fill in the
> blank>".)
> 
> Good luck - IWP is a powerful "tool" for writing reports quickly, but
> first
> you need to have a programmer's understanding of the file relationships in
> order to "tease" the data from the files.
> 
> Joan McCready, IS Manager         phone:  636-479-4499
> The Carondelet Corporation        fax:  636-479-3399
> 8600 Commercial Blvd              www.metaltekint.com
> Pevely, MO  63070            
> 
> --Original Message-----
> From: George Sagen [mailto:gsagen@csi.com]
> Sent: Thursday, October 12, 2000 1:51 PM
> To: MAPICS-L@midrange.com
> Subject: File Definitions
> 
> 
> I've been tasked with designing and writing reports and inquiries.
> How can I get a listing of all the file names and descriptions in the
> MAPICS
> library. I also want a listing of all the fields in each file. Logicals
> with
> their filters and sorts would be nice too.
> 
> Is there an AS/400 utility or MAPICS product that will generate a data
> dictionary for me and put it in a table or file I can download into a
> spreadsheet?
> 
> Many thanks,
> Geo.
> 
> +---
> | This is the MAPICS Mailing List!
> | To submit a new message, send your mail to MAPICS-L@midrange.com.
> | To subscribe to this list send email to MAPICS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MAPICS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> dshaw@spartan.com
> +---
> +---
> | This is the MAPICS Mailing List!
> | To submit a new message, send your mail to MAPICS-L@midrange.com.
> | To subscribe to this list send email to MAPICS-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MAPICS-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> dshaw@spartan.com
> +---
+---
| This is the MAPICS Mailing List!
| To submit a new message, send your mail to MAPICS-L@midrange.com.
| To subscribe to this list send email to MAPICS-L-SUB@midrange.com.
| To unsubscribe from this list send email to MAPICS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: dshaw@spartan.com
+---