I am currently in the process of developing a product to build up a picture of the BPCS system, ie. programs, files (where used), fields (where used), etc and this product is Freeware - yes Freeware.  This product will work on any AS/400 where programs have been developed using RPG II/III/400 and it will include IV/ILE in the near future. 
 
The product will build a picture on the following:
  • Libraries - used to drill down to the following:
  • Programs (Parameters, Files used, called programs, other objects, fields used (renames w/ threads),/COPY routines, subroutines, called by other programs analysis, source code and levels).
  • Database Files (Physical files, record formats, fields + references, where used, Logical files, access paths, select/omit criteria)
  • Device Files (Display Files, Printer Files - all linked to the database and programs lists)
  • Data Areas (where used, external data structures, LDA definitions)
  • Job Descriptions (where used)
  • Commands (non OS/400)
IF YOU WOULD LIKE TO BE INCLUDED IN THE DISTRIBUTION OF THIS TOOL THEN PLEASE SEND ME AN E-MAIL DIRECTLY AND NOT THROUGH THE LISTSERV.  MY E-MAIL ADDRESS IS ian.bunn@progeny400.com
 
Regards
 
Ian Bunn
Progeny/400
----- Original Message -----
Sent: 13 October 2000 14:52
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
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

This mailing list archive is Copyright 1997-2022 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.