Programs-SQL Tables Report
This report shows for each program the name of the SQL table that is referenced, the type of statement and the statement occurrences.
To generate this report, go to Explore Projects view and select Mainframe Reports list. Select Where Used Reports, then double-click the desired report to display the report wizard.
The Available Programs area displays the resources available for report generation and allows the user to select the resources to be included in the report. Use the Name field to filter the contents of the list. Place the cursor over an icon to display a tooltip about the type of resource it displays and click it to display only the selected type of resource. To display the full name of the resource type, click the white arrow button to the left of the dialog window. In Report generation options area, the selection indicates that the report appendix is displayed by default. Choose what additional data to include in the appendix: show input details in appendix. Use the arrow buttons to move the resources between the Available and Selected lists then click Next to generate the report.
The Report summary section presents two charts that show the SQL tables usage ratio and the used SQL tables distribution.
The Report details section presents for each program: the name of the SQL table that are referenced, the type of statement and the statement occurrences.