• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

File/Field Definitions

MGrejtak

Member
Does anyone know how to get a printed copy of a database file and the text
description of all the fields in that file? I would like to get a printout
of the F4211 file fields and descriptions.

Michael Grejtak, CPIM
JDEdwards Manufacturing Systems Analyst
Planning/Inventory/Shop Floor Control
Hancor, Inc.
(419)424-8253
 
Michael

Try doing a DSFFD F4211. That will give you all of the information that you
need, and then some!

Jeff Wilson
Unilever Cosmetics International


In a message dated 04/16/2001 2:19:08 PM Eastern Daylight Time,
MGrejtak@hancor.com writes:

<< Does anyone know how to get a printed copy of a database file and the text
description of all the fields in that file? I would like to get a printout
of the F4211 file fields and descriptions.

Michael Grejtak, CPIM
JDEdwards Manufacturing Systems Analyst
Planning/Inventory/Shop Floor Control
Hancor, Inc.
(419)424-8253 >>
 

JCelestino

Active Member
You can use the IBM command Display File Field Description,
DSPFFD FILE(F4211) OUTPUT(*PRINT). Prompt the command using F4 to see other
parameters you can utilize.

Janet Celestino Leppo
Business Application Developer
NJR Service Corporation
JCelestino@njresources.com <mailto:JCelestino@njresources.com>
A7.2 cume 9
 

Robert Robinson

Reputable Poster
I run a DREAM Writer using the P98DDSP form. This report has options to
display a full description of each field in a file, or the description
could be bypassed. I have run this report on the F4211, F42119, etc. and it
has come in quite handy.



Robert Robinson, CPA/CITP, CNE
Senior Business Systems Analyst
Durr, Inc.
734.459.6800
fax # 734.459.5837
e-mail address: rrobinson@durr-usa.com




MGrejtak
<MGrejtak@hancor.c To: jdeworldml@jdelist.com
om> cc:
Sent by: bcc:
owner-jdeworldml@j Subject: File/Field Definitions
delist.com


04/16/2001 02:10
PM
Please respond to
jdeworld






Does anyone know how to get a printed copy of a database file and the text
description of all the fields in that file? I would like to get a printout
of the F4211 file fields and descriptions.

Michael Grejtak, CPIM
JDEdwards Manufacturing Systems Analyst
Planning/Inventory/Shop Floor Control
Hancor, Inc.
(419)424-8253




--------------------------
 

SLewis

Member
That would be option 9 on menu G91 or form P98DDSP through the dream writer
versions list.

Stephen R. Lewis
Application Systems Administrator
CCL Custom Manufacturing
Rexdale Plant
11 Bethridge Road
Etobicoke, ON Canada
M9W 1M6
Phone: (416) 740-7400 ext155
Fax: (416) 743-5439
email: slewis@rex.cclcustom.com




Steve Lewis
CCL Custom Manufacturing
11 Bethridge Rd.
Toronto, ON Canada
M9W 1M6

A73 cum 8, 720 V4R4
 

miaconis

Active Member
The best way to get such a listing is through a file utility. If your
AS/400 does not have one, go to www.wrkdbf.com and you can download a very
good utility for free. No, I'm not kidding. It's free. If you should
decide to download and use the WRKDBF utility, display the file first, press
F14 to display a window with the file fields and then F21 to print the
window. Hope that helps.

Mike
 

MGrejtak

Member
Thanks to all of your for your help. I was not aware I had so many
different options to do this.

Michael Grejtak, CPIM
JDEdwards Manufacturing Systems Analyst
Planning/Inventory/Shop Floor Control
Hancor, Inc.
(419)424-8253
 

tpayne

Reputable Poster
The JDE option will give you any vocabulary overrides as well, which the
AS400 DSPFDD will not do.
This is very helpful when looking for definitions of user defined fields in
a file.
 

DBelcher

Active Member
Michael,

I have a "home-grown" utility that written a number of years ago by someone
else that I use all the time. It's call FFD (File Field Description) that
does an on-line display and by using a print key will give a printed
version. Give a day or so and I'll package it up for you.

Doug Belcher
KV Pharmaceutical
St Louis MO
Opinions expressed are not necessarily those of my employer


ard=W&Number=9179


Doug Belcher
St Louis MO
Opinions expressed are not necessarily those of my employer
 
Top