Re: Data Dictionary

["Peter Colpaert" <Peter.Colpaert@xxxxxxxxxxxx>]

Marsha,

try combining it with the outfile of DSPPGMREF PGM(*ALLUSR/*ALL) OUTPUT
(*OUTFILE)

This might (and probably will) take some time.

HTH,

Peter Colpaert
Application Developer

Honda Europe NV
Langerbruggestraat 104
B-9000 GENT
Belgium
Peter.Colpaert@xxxxxxxxxxxx
Tel: +32 9 2501 334
Fax: +32 9 2501 231
----------
Yoda of Borg are we: Futile is resistance. Assimilate you, we will.
----------






                                                           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



      ______________________________________________________________________
   The information contained in this communication is confidential and may
   be legally privileged. It is intended solely for the use of the
   individual or the entity to whom it is addressed and others authorised
   to receive it. If you have received it by mistake, please let the sender
   know by e-mail reply and delete it from your system.
   If you are not the intended recipient you are hereby notified that any
   disclosure, copying, distribution or taking any action in reliance of
   the contents of this information is strictly prohibited and may be
   unlawful.
   Honda Europe NV is neither liable for the proper and complete
   transmission of the information contained in this communication nor for
   any delay in its receipt.