QUSRBRM.CHANGE_ENTERPRISE_NODE Procedure

The QUSRBRM.CHANGE_ENTERPRISE_NODE procedure allows you to change an existing enterprise node.

Parameters

QUSRBRM.CHANGE_ENTERPRISE_NODE (SYSTEM_NAME=> system-name, RELATIONAL_DATABASE_NAME=> relational-database-name, PRIMARY_CONTACT=> primary-contact, SECONDARY_CONTACT=> secondary-contact, HUB_OUTPUT_QUEUE_LIBRARY=> hub-output-queue-library, HUB_OUTPUT_QUEUE=> hub-output-queue, NODE_OUTPUT_QUEUE_LIBRARY=> node-output-queue-library, NODE_OUTPUT_QUEUE=> node-output-queue, DESCRIPTION=> description)

system-name (required)

Specifies the system you want to change in the enterprise network.

Possible values are:

system-name

The system name to be changed in the enterprise network.

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

relational-database-name (optional)

Specifies the relational database name of the enterprise node.

Possible values are:

NULL

The optional value has not been specified.

relational-database-name

The relational database name of the enterprise node.

 

primary-contact (optional)

Specifies the primary contact name of the enterprise node.

Possible values are:

NULL

The optional value has not been specified.

primary-contact

The primary contact name of the enterprise node. The contact name can be up to 10 characters long and must exist in the Enterprise Contacts file.

 

secondary-contact (optional)

Specifies the secondary contact name of the enterprise node.

Possible values are:

NULL

The optional value has not been specified.

secondary-contact

The secondary contact name of the enterprise node. The contact name can be up to 10 characters long and must exist in the Enterprise Contacts file.

 

hub-output-queue-library (optional)

Specifies the output queue library name where reports are stored on the BRMS enterprise hub system.

Possible values are:

NULL

The optional value has not been specified.

hub-output-queue-library

The output queue library name where reports are stored on the BRMS enterprise hub system.

 

hub-output-queue (optional)

Specifies the output queue where reports are stored on the BRMS enterprise hub system.

Possible values are:

NULL

The optional value has not been specified.

hub-output-queue

The output queue where reports are stored on the BRMS enterprise hub system.

 

node-output-queue-library (optional)

Specifies the output queue library name where reports are stored on this BRMS enterprise node system.

Possible values are:

NULL

The optional value has not been specified.

node-output-queue-library

The output queue library name where reports are stored on this BRMS enterprise node system.

 

node-output-queue (optional)

Specifies the output queue where reports are stored on this BRMS enterprise node system.

Possible values are:

NULL

The optional value has not been specified.

node-output-queue

The output queue where reports are stored on this BRMS enterprise node system.

 

description (optional)

Specifies a description for the enterprise node.

Possible values are:

NULL

The optional value has not been specified.

description

Specifies a description for the node. The description can be up to 128 characters long.

 

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 change the relational database on the node system named SALES:

call QUSRBRM.CHANGE_ENTERPRISE_NODE(

     SYSTEM_NAME=> 'SALES', 

     RELATIONAL_DATABASE_NAME=> 'RDBSALES')

call QUSRBRM.CHANGE_ENTERPRISE_NODE(

     SYSTEM_NAME=> 'SALES', 

     RELATIONAL_DATABASE_NAME=> 'RDBSALES')

To change the description for the node system named SALES:

call QUSRBRM.ADD_ENTERPRISE_NODE( 

     SYSTEM_NAME=> 'SALES', 

     DESCRIPTION=>'Sales System' )

call QUSRBRM.ADD_ENTERPRISE_NODE( 

     SYSTEM_NAME=> 'SALES', 

     DESCRIPTION=>'Sales System' )

 

Error Messages

The following SQL States and error messages may be returned by this procedure:

U0001

Server is not valid.

U0003

Enterprise Node not found.

U0004

Relational database required.

U0005

Relational database entry not found.

U0006

Primary Contact not found.

U0007

Secondary Contact not found.

U0008

Hub Output Queue required when Hub Output Queue Library is specified.

U0009

Hub Output Queue Library required when Hub Output Queue is specified.

U0010

Hub Output Queue and/or Hub Output Queue Library not valid.

U0011

Node Output Queue required when Node Output Queue Library is specified.

U0012

Node Output Queue Library required when Node Output Queue is specified.

U0013

Node Output Queue and/or Node Output Queue Library not valid.

U0014

Unable to retrieve Enterprise Node.

U0016

Unable to change Enterprise Node.

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.