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') |
---|
To change the description for the node system named SALES:
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.