How to identify CA Datacom TABLEs with a specific FIELD?
Release: 15.1
Component: Datacom/DB
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';