What is the best way to generate a report of all fields in the all databases, is this possible to do?
In the past when doing similar actions I've generated reports for single fields but in this instance I need to generate a report that lists every single field.
A DDUTILTY field report will give you a lot of info about each field:
You could likely write a simple SQL query against, I guess, the dictionary FIELD table, if you like…
Hi David, since we are helping you in your open case, I will mark this complete here.
For the record, Clyde, we also suggested this FIELD report, and gave a process to create a COBOL copybook if that is easier for their developers.
Here's a discussion of the process to create a COBOL copybook: Re: Expansion of Datacom/DB tables in COBOL
Can you tell us what it is you are looking to do? It would help in recommending what tools to use.
There is a POC active that will export all columns from a given database to a report format and a flat file format.
If you executed the POC once for each database in the shop and combined the export files you would have all the column information (with the additional database/area/table) so they could be sorted or compared.
Clyde's answer above was used in conjunction with what I got from Don in support so I have what I need.
I ran -RPT FIELD,TABLE,ALL(PROD) to give me a list of all the fields in our Datadictionary. Our developers wished to review same as they are looking for similarly used fields across a number of databases as part of a review, fields that should have the same name but do not.