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:

The BRMS Network feature is required.

The schema is QUSRBRM.

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')

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.