[ QUOTE ]
I am an IT auditor and need help. We have the F0092, F0093, F0094 & P98OWSEC tables to test but no field/description layout of what's in each file. Where can I find this info? We have limited time and not much access to the admins. Would like to find online if possible. PLEASE HELP! Thanks to all in advance.
[/ QUOTE ]
Not sure if this will help but it will give you column descriptions for the tables you mentioned:
<font class="small">Code:</font><hr /><pre>
SELECT JDE_DV812.DV812.F98711.TDOBNM as 'Table Name',
JDE_DV812.DV812.F98711.TDSQLC as 'SQL Column Name',
JDE812.DD812.F9203.FRDTAI as 'Data Dictionary Name',
JDE812.DD812.F9203.FRDSCA as 'Column Description'
FROM JDE_DV812.DV812.F98711
JOIN JDE812.DD812.F9203
ON JDE_DV812.DV812.F98711.TDOBND = JDE812.DD812.F9203.FRDTAI
WHERE JDE_DV812.DV812.F98711.TDOBNM in ('F0092', 'F0093', 'F0094', 'F98OWSEC')
and JDE812.DD812.F9203.FRDSCC ! = '*SAME' and JDE812.DD812.F9203.FRDSCC ! = ''
ORDER by JDE_DV812.DV812.F98711.TDOBNM
</pre><hr />
This is a very rough script I just threw together and there may be more than one data dictionary description for a given column, depending on what form the field is used on. Most are similar names though so it shouldn't be a big deal.
Also, from your use of the term 'file' to refer to a table I suspect that you may be on iSeries so have one of your operators change the syntax to DB2 if necessary.