Re: Data Dictionary

Does DSPFFD show you anything, (about database files, not screens, 
printer, etc) that just querying against QSYS2/SYSCOLUMNS doesn't?  Well, 
other than eating up disk space by the output file created by DSPFFD that 
is obsolete about 5 minutes after you run the command.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 





<marsha.barton@xxxxxxxxxxxxxxxx> (Marsha Barton)
Sent by: midrange-l-bounces@xxxxxxxxxxxx
07/15/2003 06:51 AM
Please respond to Midrange Systems Technical Discussion
 
        To:     <midrange-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        Data Dictionary


My employer wants me to create a Data Dictionary to document our database. 
 I used Display File Field Description (DSPFFD) to create an output file 
of the different fields in the different files in our database.  Now I can 
Query the DSPFFD output file for the information I need.  Except, that 
next to each field, as part of this document, my employer wants the name 
of the program using that file.

Field Name    Data File Name / Description                 Program Name / 
Description                                              Type Length ....
Last Name     EmpCode / Employee number file               ENTEMPLY / 
Assign employee number              A                 35
                          EmpMast / Employee master file EMPMAST / Enter 
employee information                A                 35

Since the program name is not part of the information provided by DSPFFD, 
does anyone have any suggestions on an easy was to create another file to 
join to the original DSPFFD file?  This file should contain the program 
name and the output fields to join to the original DSPFFD file.

Marsha Barton / Computer System Tech
Brevard County Public Safety / Criminal Justice Services
1040 S. Florida Ave.
Rockledge, FL 32955
(321) 633-2006 Ext. 52330
marsha.barton@xxxxxxxxxxxxxxxx


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.