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
+---
|
midrange.com
