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.