QUSRBRM.ADD_BRMS_DISTRIBUTION_MESSAGE Procedure

The QUSRBRM.ADD_BRMS_DISTRIBUTION_MESSAGE procedure sets the message IDs to be notified for when sending email notifications for messages sent to the BRMS log.

Parameters

QUSRBRM.ADD_BRMS_DISTRIBUTION_MESSAGE (MESSAGE_ID=> message-id)

message-id

Specifies the message ID(s) you wish to distribute when sending email notifications for messages sent to the BRMS log.

Possible values are:

message-id

Specifies the messaged ID(s) to distribute when sending email notifications for messages sent to the BRMS log.  The field supports a list of 7 character blank separated message IDs, up to a maximum of 5.

 

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 identify the single message BRM1049 for email notification:

call QUSRBRM.ADD_BRMS_DISTRIBUTION_MESSAGE('BRM1049')

call QUSRBRM.ADD_BRMS_DISTRIBUTION_MESSAGE('BRM1049')

To add 2 additional messages, CPF9898 and MCH3601 for email notification:

call QUSRBRM.ADD_BRMS_DISTRIBUTION_MESSAGE('CPF9898 MCH3601')

call QUSRBRM.ADD_BRMS_DISTRIBUTION_MESSAGE('CPF9898 MCH3601')

To add 5 additional messages, CPF0001, MCH0001, BRM0001, CPF9898 and MCH3601 for email notification:

call QUSRBRM.ADD_BRMS_DISTRIBUTION_MESSAGE('CFP0001 MCH0001 BRM0001 CPF9898 MCH3601')

call QUSRBRM.ADD_BRMS_DISTRIBUTION_MESSAGE('CFP0001 MCH0001 BRM0001 CPF9898 MCH3601')

Error Messages

The following error SQLSTATEs may be returned by this procedure.

U0001

Message ID not valid.

U0002

Message ID not added.

U0003

Not all message IDs added.

U0004

No message IDs added.

U9999

Illegal execution.

 

Copyright © Fortra, LLC and its group of companies. All trademarks and registered trademarks are the property of their respective owners.