QUSRBRM.ENTERPRISE_REPORT_DEFINITION_INFO View

Owned by Peter Lafler
Sept 14, 2022
2 min read

The QUSRBRM.ENTERPRISE_REPORT_DEFINITION_INFO view shows the attributes for the current reports defined to run on the enterprise nodes. 

Authorization:  

The authorization ID of the statement must include the following privileges:

  • *OBJOPR and *READ authority to the QUSRBRM/RPT_INFO object.

Result Table

The following table describes the columns in the view. The system name is RPT_INFO. The schema is QUSRBRM.

Column Name

System Column Name

Data Type

Description

REPORT_DEFINITION

REPORT

VARCHAR(10)

The name of the report definition.

SYSTEM_NAME

SYSTEM

VARCHAR(17)

The system name of the node in the enterprise network where the report will run.

The possible values are:

  • *ALLNODES  The report definition is enable for all systems defined in the enterprise network.

  • system-name

Note: The system format is nnnnnnnn.ssssssss where nnnnnnnn is the network identifier and ssssssss is the local location name.

SEND_ERROR_EMAIL

SENDERROR

VARCHAR(3)

 

Send an email notification to the node and hub contacts when errors occur in the network.

The possible values are:

  • NO

  • YES

SEND_REPORT_EMAIL

SENDREPORT

VARCHAR(3)

 

Send an email notification to the node and hub contacts with the reports generated in the network.

The possible values are:

  • NO

  • YES

FREQUENCY_INTERVAL

FREQUENCY

VARCHAR(6)

 

The frequency of how often to run the report.

The possible values are:

  • DAYS

  • WEEKLY

WAIT_DAYS

WAIT_DAYS

INTEGER

The number of days to wait before running the report again. Valid range: 0 to 999

This value is only valid when the field FREQUENCY_INTERVAL is DAYS.

RUN_SUNDAY

SUNDAY

VARCHAR(3)

Nullable

Run the report on Sunday. 

The possible values are:

  • NO

  • YES

Contains the null value if the FREQUENCY_INTERVAL is DAYS.

RUN_MONDAY

MONDAY

VARCHAR(3)

Nullable

Run the report on Monday. 

The possible values are:

  • NO

  • YES

Contains the null value if the FREQUENCY_INTERVAL is DAYS.

RUN_TUESDAY

TUESDAY

VARCHAR(3)

Nullable

Run the report on Tuesday. 

The possible values are:

  • NO

  • YES

Contains the null value if the FREQUENCY_INTERVAL is DAYS.

RUN_WEDNESDAY

WEDNESDAY

VARCHAR(3)

Nullable

Run the report on Wednesday.

The possible values are:

  • NO

  • YES

Contains the null value if the FREQUENCY_INTERVAL is DAYS.

RUN_THURSDAY

THURSDAY

VARCHAR(3)

Nullable

Run the report on Thursday.

The possible values are:

  • NO

  • YES

Contains the null value if the FREQUENCY_INTERVAL is DAYS.

RUN_FRIDAY

FRIDAY

VARCHAR(3)

Nullable

Run the report on Friday.

The possible values are:

  • NO

  • YES

Contains the null value if the FREQUENCY_INTERVAL is DAYS.

RUN_SATURDAY

SATURDAY

VARCHAR(3)

Nullable

Run the report on Saturday.

The possible values are:

  • NO

  • YES

Contains the null value if the FREQUENCY_INTERVAL is DAYS.

GENERATION_TIME

GEN_TIME

TIME(0)

The time of day to run this report.

NUMBER_REPORTS_TO_STORE

NUMREPORTS

INTEGER

The number of previously generated reports to keep. Valid range: 0 to 99,999

REPORT_COMMAND

COMMAND

VARGRAPHIC(7000)

CCSID 1200

The full command used to run the report.

TEXT_DESCRIPTION

TEXT

VARGRAPHIC(128)

CCSID 1200

Nullable

The text description of the report definition.

Contains the null value if the text description is not set.

Examples

Example 1: Report commands being run weekly on Mondays

 

SELECT REPORT_DEFINITION, SYSTEM_NAME, FREQUENCY_INTERVAL, RUN_MONDAY, GENERATION_TIME, REPORT_COMMAND FROM QUSRBRM.ENTERPRISE_REPORT_DEFINITION_INFO WHERE FREQUENCY_INTERVAL='WEEKLY' AND RUN_MONDAY = 'YES'

Example output:

REPORT_DEFINITION
SYSTEM_NAME
FREQUENCY_INTERVAL
RUN_MONDAY
GENERATION_TIME
REPORT_COMMAND

RECOVERY

*ALLNODES

WEEKLY

YES

10:00:00

QSYS/STRRCYBRM OPTION(*SYSTEM) ACTION(*REPORT)

BACKUPSTAT

APPN.SYSTEM1

WEEKLY

YES

11:00:00

QSYS/PRTRPTBRM

 

Example 2: Reports that are sending email notification when the reports are generated

 

SELECT REPORT_DEFINITION, SYSTEM_NAME, SEND_REPORT_EMAIL FROM QUSRBRM.ENTERPRISE_REPORT_DEFINITION_INFO WHERE SEND_REPORT_EMAIL ='YES'

Example output:

REPORT_DEFINITION

SYSTEM_NAME

SEND_REPORT_EMAIL

RECOVERY

*ALLNODES

YES

BACKUPSTAT

APPN.SYSTEM1

YES

Privacy Policy | Cookie Policy | Impressum
From time to time, this website may contain technical inaccuracies and we do not warrant the accuracy of any posted information.
Copyright © Fortra, LLC and its group of companies. All trademarks and registered trademarks are the property of their respective owners.