list of views and procedures
Article ID: 10493
Updated On:
Products
Issue/Introduction
Customer would like to list all the SQL VIEW he has created so far.
Environment
Resolution
-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
See CA Datacom/DD Batch Reference Guide.
or
https://docops.ca.com/ca-datacom/15-1/en
or
https://docops.ca.com/ca-datacom/15-0/en
Feedback
