Customer would like to list all the SQL VIEW he has created so far.
-1-To list the VIEWs, run a DDUTILTY INDEX report:
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 ;
-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: