CA Datacom SQL Security › Implementing the SQL Security Model › Adding View Security Authorizations › Using DDUTILTY to Display Relationships

Using DDUTILTY to Display Relationships

Alternately, you can use DDUTILTY with the following input to create a report showing the relationships.

 -DEF PATH,VIEW-USES-TABLES
 -DEF TRACE,VIEW.TABLE,VEW-TBL-DEPENDS
 -END
 -DEF PATH,VIEW-USED-BY-PROGRAMS
 -DEF TRACE,VIEW.STATEMENT,STM-VEW-DEPENDS
 -DEF TRACE,STATEMENT.PLAN,PLN-STM-CONTAIN
 -DEF TRACE,PLAN.PROGRAM,PGM-PLN-USES
 -END
 -RPT START,VIEW,ALL(PROD),VIEW-USES-TABLES
 -END
 -RPT START,VIEW,ALL(PROD),VIEW-USED-BY-PROGRAMS
 -RPT INDENT,VIEW
 -RPT INDENT,PLAN
 -RPT INDENT,PROGRAM
 -END
 -RPT INDENT,PLAN
 -RPT INDENT,PROGRAM
 -END