Crystal Rpt dumping data dictionary detail by table

Does anyone out there have a crystal report that they would be willing to share with us?

We are looking for a rpt that lists the data attributes in each table as follows:

1) Table
2) Data attribute alias
3) Data brief description
4) Type
5) Length
6) Data Item
7) Long Data Dictionary Description of each attribute
8) Additional data dictionary items (see attached document)

Or could someone identify for us all the Tables that interact with the data dictionary.

Cathy,

F9860 - Table Object Header
F98711 - Table Columns
F9210 - DD Data Field Specifications
F9203 - Data Item Alpha Descriptions

Regards,

Cathy,

Here is an Oracle SQL query that I use. I think it will provide the information you are after. The results include the following information:

Information - (Source)
File Name - (ALL_TAB_COLUMNS.TABLE_NAME)
File Description - (OBJ7333.F9860.SIMD)
Field Name - (ALL_TAB_COLUMNS.COLUMN_NAME)
Field Description - (DD7333.F9202.FRDSCR)
Field Type (OW) - (PRODCTL.F0005.DRDL01)
Field Length (OW) - (DD7333.F9210.FRDTAS)
Field Type (Oracle) - (ALL_TAB_COLUMNS.DATA_TYPE)
Field Length (Oracle) - (ALL_TAB_COLUMNS.DATA_LENGTH)
One World Data Dictionary Item - (DD7333.F9210.FROWDI)
Edit Rule - (DD7333.F9210.FROWER)
Edit Rule Spec 1 - (DD7333.F9210.FROER1)
Edit Rule Spec 2 - (DD7333.F9210.FROER2)
Field Number - (ALL_TAB_COLUMNS.COLUMN_ID)

SQL Query

<font color="blue"> You may wish to tweak the parts of the WHERE clause that are blue. </font>

SELECT A.TABLE_NAME, D.SIMD, A.COLUMN_NAME, C.FRDSCR, E.DRDL01, B.FRDTAS,
A.DATA_TYPE, A.DATA_LENGTH, B.FROWDI, B.FROWER, B.FROER1, B.FROER2, A.COLUMN_ID
FROM ALL_TAB_COLUMNS A, DD7333.F9210 B, DD7333.F9202 C, OBJ7333.F9860 D, PRODCTL.F0005 E
WHERE <font color="blue"> A.OWNER IN ('PRODDTA', 'PRODCTL', 'SYS7333', 'OBJ7333', 'DD7333', 'PD7333')
AND A.TABLE_NAME LIKE 'F09%' </font>
AND RTRIM(SUBSTR(A.COLUMN_NAME, 3, 10)) = RTRIM(B.FRDTAI)
AND RTRIM(SUBSTR(A.COLUMN_NAME, 3, 10)) = RTRIM(C.FRDTAI)
AND RTRIM(A.TABLE_NAME) = RTRIM(D.SIOBNM)
AND LTRIM(RTRIM(B.FROWTP)) = LTRIM(RTRIM(E.DRKY))
AND C.FRSYR = ' '
AND D.SIFUNO = 'TBLE'
AND E.DRSY = 'H98' AND E.DRRT = 'DT'
ORDER BY A.TABLE_NAME, A.COLUMN_ID

Peter, you are awesome. Thank-you very much for the information. I put my post out here and then I did not get a chance to go back and check it till today. Was busy with two rush projects. Everyone knows how that is.

Thank-you again. If we have any questions regarding this SQL we will be sure to ask you.