SAVE REPORT

SAVE REPORT stores a report (definition and data) so that it can be viewed at a later date.

Note: For the security associated with saved reports, see Security for ASF tables.

Batch considerations

SAVE REPORT is invalid when running local mode.

Syntax:

►►─── SAVe REPort ─┬─────┬─ report-name ──────────────────────────────────────►
                   └─ = ─┘

 ►─┬────────────────────────────┬─────────────────────────────────────────────►
   └─ USEr ─┬─────┬─ user-name ─┘
            └─ = ─┘

 ►─┬────────────────────────────────────────┬─────────────────────────────────►◄
   └─ RETention period ─┬─────┬─ days days ─┘
                        └─ = ─┘

Parameters:

report-name

The 1 to 32-character name of the report to be saved.

USER= user-name

Specifies the user into whose directory the report is saved. If user-name is not specified, the report is saved under the current user name.

RETENTION PERIOD= days

Specifies the number of days for which the report is saved.

A default retention period and a maximum retention period are established at DC/UCF system generation. Reports are automatically deleted at the end of their associated retention periods.

Example:

The report file used for this example was initially created by execution of the following SELECT statement:

select office-code-0450,office-phone-0450(1),emp-id-0415
 from office, employee
 where office-employee

The following SAVE REPORT command stores the report, created by the SELECT statement shown above, in the data dictionary and associates the report with the name OFFICE#8. After the OFFICE#8 report has been stored, CA OLQ displays a message to indicate that processing has been completed successfully:

save report=office#8 retention period=10 days

OLQ 107001 00  The OFFICE#8 report has been saved successfully

This report can then be viewed at a later time using DISPLAY:

display report = office#8