How to identify CA Datacom TABLEs with a specific FIELD?

book

Article ID: 15152

calendar_today

Updated On:

Products

CA Datacom CA Datacom - AD CA Datacom/AD

Issue/Introduction

How to identify CA Datacom TABLEs with a specific FIELD?

Environment

Release: 15.1
Component: Datacom/DB

Resolution

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';

 

Additional Information

Also see Article 194158 - CA Datacom report on field names that contain specific character pattern