list of views and procedures

Document ID : KB000010493
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

Customer would like to list all the SQL VIEW he has created so far.

Environment:
z/OS or z/VSE with CA Datacom
Instructions:

-1-To list the VIEWs, run a DDUTILTY INDEX report: 

-RPT INDEX,VIEW

or

-RPT INDEX,VIEW,ALL 

A DETAIL report will list the attribute-types and the current attributes. 

 

-2-To see the content, use the DDTRSLM EXPORT feature to extract the VIEW:

EXPORT VIEW RAMISIVP.SALESVIEW ; 

or

-3- DDUTILTY TEXT report: 

-RPT TEXT,VIEW,viewname(PROD) will print the TEXT (SQLSOURCE) for VIEWs. 

 

Instead of VIEW you may use PROCEDURE to list the PROCEDURE . 

 

-4-To list all the SQL views with their tables related to them, the following DDUTILTY report generates this list:

-DEF PATH,IMPACT1 

-DEF TRACE,VIEW.TABLE,VEW-TBL-DEPENDS 

-END 

-RPT START,VIEW,,IMPACT1 

-RPT INDENT 

Additional Information: