World table list

All-

Is there anyone that can lead me to a complete list of the tables, and their functions in World A7.3?

Thanks
-Tim

World A7.3, AS/400, V5R3

If you go into the list of UDC tables (if you have access just type "UDC"), press F5 to view the code types.
Specify a System Code (eg: "00") and this will display a list of the UDC tables for that system and how they are defined.
This is also where you define your own tables for local programs.
Hope this helps.
Also - it's in the Technical Foundation Manuals...........
They make a very useful read - answer all types of basic questions...

I read his question differently. Are you looking for all of the database tables (not UDC Tables) that are used in JDE? If so, that's going to be a long list! Sadly, most of it is in my head but I do recall seeing bits and pieces of such a list in "programmers guides" from years ago. I do belive there is a section in the Technical Foundations manual that goes over some of the "major" files but it by no means is complete. Hope that helps.

I suppose you could scavenge through the F9801 (SVR) file and look for all type "PF" entries and that might give you a nice list?

If you are looking for all files and you are on a A/S400 then you could use
command DSPOBJD







Then do DSPFFD







Then you can either use SQL or Query to select ODOBTP = *file and ODOBST
= PF



_____

From: [email protected] [mailto:[email protected]] On
Behalf Of ssolberg
Sent: Wednesday, July 19, 2006 4:50 PM
To: [email protected]
Subject: Re: World table list



I read his question differently. Are you looking for all of the database
tables (not UDC Tables) that are used in JDE? If so, that's going to be a
long list! Sadly, most of it is in my head but I do recall seeing bits and
pieces of such a list in "programmers guides" from years ago. I do belive
there is a section in the Technical Foundations manual that goes over some
of the "major" files but it by no means is complete. Hope that helps.

I suppose you could scavenge through the F9801 (SVR) file and look for all
type "PF" entries and that might give you a nice list?

Sannan Solberg Programmer/Developer/Anything-They-Give-Me World A7.3 c11

_____


The entire <http://www.jdelist.com/ubb/showflat.php?Cat=&Board=> JDELIST
thread is available for viewing.


Looking for a job? Check out the Job
forum


This is the JDELIST World Mailing List.
The instructions on how to unsubscribe from any JDELIST mailing list are
available here <http://www.jdelist.com/unsubscr.shtml> .
JDELIST is not affiliated with JDEdwardsR.

.

To unsubscribe from this list via email, Click
<mailto: [email protected]?Subject=Unsubscribe&Body=Sirs,

P
lease remove this address from the JDELIST World Mailing%

You can get a full list of the Physical Files by taking option 9/G91 - but that's going to be a horrendously long list of all the file structures. Doing a Query on the SVR file might be easier.

I agree with Sannan - make use of the Technical Foundation Manual.

Try the attached document. It is for One World (not World) but most of the files are same.


Matt