Finding Datacom dataviews on a database
Article ID: 10344
Updated On:
Products
Issue/Introduction
Sometimes a Datacom/Ideal DBA needs to know what dataviews could be affected by a change on a specific database.
Resolution
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
/*
These are the first few rows from the report that was run on the PROD version of the 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 table names are not needed in the report , change the card:
-DEF TRACE,AREA.TABLE,$INTERNAL
to
-DEF TRACE,AREA.TABLE,$INTERNAL,SKIP
Additional Information
Feedback
