Re: How to Navigate On Database Fields?

Ozgur

Let me suggest you use your F1 function key - put your cursor on the item you are interested in and press F1 - almost all IBM software has context-sensitive help that can answer most of your questions. This applies to green-screen output as well as the graphical output.

HTH
Vern

On 7/20/2012 12:51 AM, Ozgur Isiklar wrote:

Dear SJL;

Many thanks for your kind helps :) Now I can view the field names.

I'd appreciate if you could kindly guide me what do the colored parameters
mean?

1st Column: ??
2nd Column: ??
3rd Column: ??
4th Column: Alphanumerical Length?

98FFD File Field Descriptions S/FMT
File and Libr: F0411 FRPDTA PF
I0411 - Accounts Payable Ledger
RPKCO Document Company . . A 5 1
RPDOC Document Number. . . S 8 0 6
RPDCT Document Type. . . . A 2 14
Thanks - Kind Regards,
Ozgur
2012/7/20 sjl <sjl_abc@xxxxxxxxxxx>

Ozgur -

Use JDE 'Hidden Selection' number 40 on any JDE menu...

This will cause the JDE 'File Fields Description' window to pop up, which
allows you to enter the file name and library name.

If you then press <Enter>, it will show the list of fields in the file,
along with their descriptions and attributes. While viewing the
information
for a file, you can enter '2' into the selection option field for the file
fields and view the JDE Data Dictionary information.

- sjl


"Ozgur Isiklar" wrote in message
news:mailman.10239.1342619244.2513.midrange-l@xxxxxxxxxxxx...

Hi Friends;

Can you please how I can inquire and know the database columns and field
names (together with their real names/synonyms ) in AS/400 ISeries?

Through AS/400 Operations Navigator? or through any other supplemental
tools?

*For example*:

*GLPN.....G/L Period Number*
*GLLT......Ledger Type*
*GLDCT........Document Type*
*GLDOC........Document Number*

Maybe it's one of the minor issues for most of you (IBM experts), however a
major question for such non-technical persons like me :)


--
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.