How to identify the Datacom TABLEs with a specific FIELD?

Document ID : KB000015152
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

How to identify the Datacom TABLEs with a specific FIELD?

Answer:

Here are ways to determine which TABLEs have a certain FIELD:

DDUTILTY/DDUPDATE report with "ALL" to give all the TABLEs and their HIST/Test/Prod versions:

-USR DATACOM-INSTALL,NEWUSER
-DEF PATH,P1
-DEF TRACE,FIELD.TABLE,$INTERNAL
-END
-RPT START,FIELD,field(ALL),P1
-RPT INDEX
-END

SQL request (only gives current production version):

SELECT ENTITY_NAME, RECORD_NAME
FROM SYSADM.FIELD
WHERE ENTITY_NAME = 'field';