QUSRBRM.REMOVE_ENTERPRISE_REPORT_DEFINITION Procedure

The QUSRBRM.REMOVE_ENTERPRISE_REPORT_DEFINITION procedure removes an existing enterprise report definition.

Parameters

QUSRBRM.CHANGE_ENTERPRISE_REPORT_DEFINITION (REPORT_DEFINITION=> report-definition, SYSTEM_NAME=> system-name)

report-definition (required)

Specifies the unique report definition name.

Possible values are:

report-definition

Specifies the unique report definition name. The report definition is not case-sensitive and must be 1 to 10 characters long.

 

system-name (required)

Specifies the system name associated with the report definition.

Possible values are:

*ALLNODES

Specifies to run this report definition on all nodes in the enterprise network.

system-name

Specifies the system name where the report definition will be run.

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

Authorization: The privileges held by the authorization ID of the statement must include the following:

  • *EXECUTE SQL privilege on this procedure

The BRMS Network feature is required.                           

The schema is QUSRBRM.

Examples:

To remove the report definition named WEEKLY, which runs on all nodes:

call QUSRBRM.REMOVE_ENTERPRISE_REPORT_DEFINITION(

       REPORT_DEFINITION=> 'Weekly',

       SYSTEM_NAME=> '*ALLNODES')

call QUSRBRM.REMOVE_ENTERPRISE_REPORT_DEFINITION(

       REPORT_DEFINITION=> 'Weekly',

       SYSTEM_NAME=> '*ALLNODES')

To remove the report definition named DAILY for system APPN.SYSTEM1:

call QUSRBRM.REMOVE_ENTERPRISE_REPORT_DEFINITION(

      REPORT_DEFINITION=>'Daily',

      SYSTEM_NAME=>'APPN.SYSTEM1')

call QUSRBRM.REMOVE_ENTERPRISE_REPORT_DEFINITION(

      REPORT_DEFINITION=>'Daily',

      SYSTEM_NAME=>'APPN.SYSTEM1')

Error Messages

The following error SQLSTATEs may be returned by this procedure:

U0001

Report Definition name is not valid.

U0002

Server is not valid.

U0005

Report Definition for specified system not found.

U0020

Unable to retrieve Report Definition.

U0023

Unable to remove Report Definition.

U9997

Functional authority to BRMS Enterprise QIBM_Q1A_ENT required.

U9998

BRMS Network and Advanced Functions features required.

U9999

Illegal execution.

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.