SQL Enterprise Procedures

Owned by Aaron Fistler
Sept 15, 2022

Hub Procedures

Change the enterprise hub attributes using the SQL procedure QUSRBRM.CHANGE_ENTERPRISE_HUB.

Example: Change the refresh rate to 60 minutes

CALL QUSRBRM.CHANGE_ENTERPRISE_HUB(REFRESH_RATE=> '60')

Contact Procedures

Add enterprise contacts using the SQL procedure QUSRBRM.ADD_ENTERPRISE_CONTACT

Example:

CALL QUSRBRM.ADD_ENTERPRISE_CONTACT(

CONTACT_USER_NAME=> 'CONTACT',

EMAIL_ADDRESS=> 'CONTACT.USERID@COMPANY.COM',

first_name=> 'FIRST',

last_name=> 'LAST',

PRIMARY_PHONE=> '111-222-3333',

SECONDARY_PHONE=> '444-555-6666',

DESCRIPTION=> 'BRMS ENTERPRISE CONTACT' )

Change the enterprise contacts using the SQL procedure QUSRBRM.CHANGE_ENTERPRISE_CONTACT.

Example : Change the email address for user name CONTACT

CALL QUSRBRM.CHANGE_ENTERPRISE_CONTACT(

CONTACT_USER_NAME=> 'CONTACT',

EMAIL_ADDRESS=> 'NEW.USERID@COMPANY.COM' )

Remove enterprise contacts using the SQL procedure QUSRBRM.REMOVE_ENTERPRISE_CONTACT.

Example:

CALL QUSRBRM.REMOVE_ENTERPRISE_CONTACT(

CONTACT_USER_NAME=> 'CONTACT')

Node Procedures

Add nodes to the enterprise network using the SQL procedure QUSRBRM.ADD_ENTERPRISE_NODE.

Example: Adding a single node

CALL QUSRBRM.ADD_ENTERPRISE_NODE (

SYSTEM_NAME=> 'APPN.BRMS1',

RELATIONAL_DATABASE_NAME=> 'BRMS1',

ADD_NETWORK_SYSTEMS=> 'NO',

PRIMARY_CONTACT=> 'CONTACT')

Change nodes to the enterprise network using the SQL procedure QUSRBRM.CHANGE_ENTERPRISE_NODE.

Example: Change the node primary contact name

CALL QUSRBRM.CHANGE_ENTERPRISE_NODE(

SYSTEM_NAME=> 'APPN.BRMS1',

PRIMARY_CONTACT=> 'CONTACT1')

Remove nodes from the enterprise network using the SQL procedure QUSRBRM.REMOVE_ENTERPRISE_NODE.

Example:

CALL QUSRBRM.REMOVE_ENTERPRISE_NODE(

SYSTEM_NAME=> 'APPN.BRMS1')

Report Definition Procedures

Add report definitions for the enterprise network using the SQL procedure QUSRBRM.ADD_ENTERPRISE_REPORT_DEFINITION.

Example: Add a report definition to run STRMNTBRM daily

CALL QUSRBRM.ADD_ENTERPRISE_REPORT_DEFINITION(

REPORT_DEFINITION=>'BRMSMNT',

SYSTEM_NAME=>'APPN.BRMS1',

GENERATION_TIME=> '100000',

COMMAND=> 'STRMNTBRM PRTEXPMED(*YES) PRTBKUACT(*YES) PRTRCYRPT(*ALL)',

FREQUENCY_INTERVAL=> 'DAYS',

WAIT_DAYS=>'1',

SEND_ERROR_EMAIL=> 'YES',

NUMBER_REPORTS=> '7',

SEND_REPORT_EMAIL=>'YES',

DESCRIPTION=> 'RUN EVERY DAY')

Change report definitions for the enterprise network using the SQL procedure QUSRBRM.CHANGE_ENTERPRISE_REPORT_DEFINITION.

Example: Change the time to run to 6am

CALL QUSRBRM.CHANGE_ENTERPRISE_REPORT_DEFINITION(

REPORT_DEFINITION=>'BRMSMNT',

SYSTEM_NAME=>'APPN.BRMS1',

GENERATION_TIME=> '060000')

Manually run a report definitions for the enterprise network using the SQL procedure QUSRBRM.RUN_ENTERPRISE_REPORT_DEFINITION.

Example:

CALL QUSRBRM.RUN_ENTERPRISE_REPORT_DEFINITION(

REPORT_DEFINITION=>'BRMSMNT',

SYSTEM_NAME=>'APPN.BRMS1')

Remove report definitions for the enterprise network using the SQL procedure QUSRBRM.REMOVE_ENTERPRISE_REPORT_DEFINITION.

Example:

CALL QUSRBRM.REMOVE_ENTERPRISE_REPORT_DEFINITION(

REPORT_DEFINITION=>'BRMSMNT',

SYSTEM_NAME=>'APPN.BRMS1')

 

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.