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') |
|---|
To remove the report definition named DAILY for system 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 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. |