Load SEQUEL Report (LOADREPORT) Command
If you have licensed the SEQUEL data retrieval and manipulation product from Fortra, Abstract can document relations between SEQUEL reports and the SEQUEL views used by those reports.
SEQUEL reports are built over SEQUEL views and use the view to retrieve data for processing by the report definition. The report definition gives users extensive formatting control over view results as well as calculation capabilities not available in SQL. The LOADREPORT command will cross reference the view used by each report. This information will be presented on Abstract object relation displays and reports.
If your application does not include any SEQUEL report objects, you need not execute this part of the initialization process.
The LOADREPORT command is automatically run as part of the LOADXREF TYPE(*ALL) job stream. You can also run the LOADREPORT command from any command entry line. The command can also be run from within a batch or interactive program. The syntax for the LOADREPORT command is shown below:
figure 15 - LOADREPORT Command Diagram
REPORT Parameter - Specify the qualified name of the report object(s) to be analyzed. A generic name (leading characters followed by an asterisk) can be specified to select objects with similar names. Specify a library name to be searched for the view(s) indicated or use one of the following special values:
*CURLIB: Your job’s current library will be searched for the views that meet the object name part of the search criteria.
*USRLIBL: The user portion of your job’s library list will be searched for the views that meet the object name part of the search criteria.
*ALLUSR: All user libraries will be searched for the views that meet the object name part of the search criteria.
*ALL: All libraries on the system will be searched for the views that meet the object name part of the search criteria.
The name portion of the VIEW parameter specifies the views that will be analyzed.
*ALL: Loads all reports in the specified library(s).
Name: specify the name of an individual view, or use a generic name (one to nine characters suffixed with an asterisk, e.g. CUST*) to indicate that all views sharing the prefix should be loaded.
DTASET Parameter - Specifies the name of the data set you want to load information into. You can accept the default or choose a separate data set, created by the Add Data Set (ADDDTASET) command, to contain the information. If the data set does not exist, an error will occur. The list of current data set names can be accessed by prompting the data set parameter.
*PRV: Use the value for this parameter from the previous session. If no previous session has occurred, use *FIRST.
*FIRST: all information should be stored in the default data set.
Name: the data set you want to use.
*USRSPC: Load information for user space type reports. User space reports are the type of report created by current versions of SEQUEL.
*DTAARA: Load information for data area type reports. Data area reports are the type of report created by the original versions of SEQUEL.
Examples
LOADREPORT *ALL
Use this command to search your current library (*CURLIB) and load cross references with all the reports in it.
LOADREPORT PRDLIB/CUST*
The library PRDLIB will be searched for reports beginning with CUST. Abstract will find reports such as CUSTVR1, CUSTLISTR, etc. The cross reference dictionary will be loaded so that you will be able to see the view that each report uses through the object relations displays and reports.