Field names

jthedorf

Member
Can anybody tell me if there is a file that contains the Field Names and the Text Description of the fields? I know I could do a DSPFFD to get the Text Description, buit was wondering if this data is already contained in a file.
 
In the Hidden Selections there is an option; File Field Description- Sel 40
( Enter in a '40' from the command line on any menu) that displays the
Field names and text description. From here you can also go to the Data
Dictionary for each field.

World User A8.1

Andrew Harrison
MIS Project Manager
VPI, LLC
1389 School House Road
Delaware City, DE 19706
Tel: (302) 836-7539
Fax: (302) 836-7622

email: mailto:[email protected]
Web Page: HTTP://WWW.VPICORP.COM
 
You have to dump your desired file field description into output file to
retrieve it, for example to retrieve fiel field description for F0006 you
need to issuse the following command:

DSPFFD FILE(F0006) OUTPUT(*OUTFILE) OUTFILE(QTEMP/X)

Then you can view file X or you can use it in HLL (RPG) program.
The IBM system output file for DSPFFD is QADSPFFD.

Emad Banoub
MWH Global Inc.
Pasadena, CA
626-568-6529
A7.3 cu 12/X3 - Xe SP 13.0






jthedorf <[email protected]>@jdelist.com on 06/21/2001 08:04:30 AM
 
If it's a JDE file - you can go to 9/G91 (Data Base Specifications) - copy
one of the versions and put your file in the parameter and it will create a
spool file for you.

Although, I personally like the DSPFFD command.

Kristian
 
J,

Time for you to hit the JDE reference guides especially the technical ones
like Technical Foundation etc. Attendance at one or two JDE technical
training courses (Tech Foundation, Programming Concepts etc) would benefit
you greatly as well.

Functionally you probably should be using SVR and the Data Dictionary or
even simpler maybe Hidden Selection 40 for any specific file. The
information you want is in various files in JDE but to even begin trying to
describe which ones and how to get want you need (an I don't have a clear
definition of your requirement) would be a long process via JDEList.

Regards...... Colin HUGILL




Colin Hugill
Consultant
 
Or you can do a "40" on the command line.




Jill Fralick
ABB Flexible Automation
Auburn Hills, MI 48313
A7.3 cum 10
(248) 391-8618
 
There is a report I stumbled across that lists this information. Go to the
Software Versions Repository (type SVR) and inquire on the file. Then put a
25 in the Options field and press enter. This will generate a list of the
field names and text descriptions, plus the Length Dec Type information for
each field.

__________________________________________________

Jon Curry
Farmers Co-operative Dairy Limited A7.3 Cum 8

Mailing Address:
P.O. Box 8118
Halifax, Nova Scotia, Canada B3K 5Y6

Physical Address:
745 Hammonds Plains Road
Bedford, Nova Scotia, Canada B4B 1A8

Phone: (902) 835-4005 Ext. 3155
Fax: (902) 835-1583
E-mail: [email protected]
 
There are DDS for these members in jdesrc/jdfsrc F98FRFA thru F98FRFZ and
also F98FRF$,F98FRF@ . I think this is whatyou are asking for.
 
Back
Top