jamest
Member
I want to learn the structure of talbes in JDE.But I can not find the detail information about it in JDE help document.How can I get this information?
peterbruce
Legendary Poster
There are at least a couple of ways to get the table structure information. Some better than others. Here are a few I know. Others may know more or better methods.
1) Print out the table structure from OMW.
2) There is an MS Access application (free?) that can interrogate your database and populates an MS Access database and reports the table structures etc. It's called "OneWorld Interrogator 2000.mde"
3) I have written an Oracle SQL statement that returns table and field/row information including any links to UDC's. I then paste the output of the SQL into a formatted Excel spreadsheet for presentation. I have also written a macro to split the list of table/rows to separate spreadsheets within the workbook - one table per sheet.
1) Print out the table structure from OMW.
2) There is an MS Access application (free?) that can interrogate your database and populates an MS Access database and reports the table structures etc. It's called "OneWorld Interrogator 2000.mde"
3) I have written an Oracle SQL statement that returns table and field/row information including any links to UDC's. I then paste the output of the SQL into a formatted Excel spreadsheet for presentation. I have also written a macro to split the list of table/rows to separate spreadsheets within the workbook - one table per sheet.
Ian_Simmons
Active Member
There's also P80010, Table Columns Browse, though the tables it reads (F98710-F98713) may have to be mapped via OCM.
