Sometimes a Datacom/Ideal DBA needs to know which are the dataviews that could be affected by a change on a specific database.
Here are some DDUTILTY cards that provide the list of the Dataviews related to a specific database:
//SYSIN DD *
-USR DATACOM-INSTALL NEWUSER
-DEF PATH,PATH1
-DEF TRACE,DATABASE.AREA,$INTERNAL,SKIP
-DEF TRACE,AREA.TABLE,$INTERNAL
-DEF TRACE,TABLE.ELEMENT,$INTERNAL,SKIP
-DEF TRACE,ELEMENT.DATAVIEW,$INTERNAL
-DEF TRACE,TABLE.KEY,$INTERNAL,SKIP
-DEF TRACE,KEY.DATAVIEW,$INTERNAL
-END
-RPT START,DATABASE,database(vers),PATH1
-RPT INDENT,,ALIGN
-END
/*
Here the first few rows from the report that I ran on PROD version of ORDER-ENTRY database::
BAS ORDER-ENTRY P 0001
ORDER ENTRY SAMPLE DATABASE
TBL ACCTS P 0001
ORDER ENTRY DEMO ACCTS FILE
SYSADM.ACCTS I A
DVW ACCOUNTS P 0003
OE ACCOUNTS RECEIVABLE FULL REC
DVW ACTCUSID P 0003
ORDER ENTRY DATAVIEW
DVW ACTORDID P 0003
ORDER ENTRY DATAVIEW
TBL CUST P 0001
CUSTOMERS TABLE
SYSADM.CUST I
DVW CUSTADDR P 0003
ORDER ENTRY DATAVIEW
DVW CUSTID P 0003
ORDER ENTRY DATAVIEW
DVW CUSTOMERS P 0003
ORDER ENTRY DATAVIEW
If you don't need to know the table names, simply change the card:
-DEF TRACE,AREA.TABLE,$INTERNAL
to read:
-DEF TRACE,AREA.TABLE,$INTERNAL,SKIP
See also:
TEC1878436: How to find which Datacom dataviews exist on a Datacom table?
TEC466435: How do I find out which CA Ideal programs are related to a CA Datacom table?