QUSRBRM.ADD_ENTERPRISE_CONTACT Procedure

The QUSRBRM.ADD_ENTERPRISE_CONTACT procedure adds a contact to BRMS enterprise.

Parameters

QUSRBRM.ADD_ENTERPRISE_CONTACT (CONTACT_USER_NAME=> contact-user-name, EMAIL_ADDRESS=> email-address, FIRST_NAME=> first-name, LAST_NAME=> last-name, PRIMARY_PHONE=> primary-phone, SECONDARY_PHONE=> secondary-phone, DESCRIPTION=> description)

contact-user-name (required)

Specifies the unique contact ID. Possible values are:

contact-user-name

Specifies the unique contact user name.  The contact user name is not case-sensitive and must be 1 to 10 characters long.

 

email-address (optional)

Specifies the email address of the contact. Possible values are:

NULL

The optional value has not been specified.

email-address

Specifies the email address of the contact. The email address can be up to 128 characters long.

 

first_name (optional)

Specifies the contact’s first name. Possible values are:

NULL

The optional value has not been specified.

first_name

Specifies the first name of the contact. The first name can be up to 20 characters long.

 

last_name (optional)

Specifies the contact’s last name. Possible values are:

NULL

The optional value has not been specified.

last_name

Specifies the last name of the contact. The last name can be up to 40 characters long.

 

primary_phone (optional)

Specifies the contact’s primary phone number. Possible values are:

NULL

The optional value has not been specified.

primary_phone

Specifies the primary phone number of the contact. The primary phone number can be up to 26 characters long.

 

secondary_phone (optional)

Specifies the contact’s secondary phone number. Possible values are:

NULL

The optional value has not been specified.

secondary_phone

Specifies the secondary phone number of the contact. The secondary phone number can be up to 26 characters long.

description (optional)

Specifies a description for the contact. Possible values are:

NULL

The optional value has not been specified.

description

Specifies a description for the contact. 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 add a new contact named Adam without any additional details:

call QUSRBRM.ADD_ENTERPRISE_CONTACT( CONTACT_USER_NAME=> 'Adam' )

call QUSRBRM.ADD_ENTERPRISE_CONTACT( CONTACT_USER_NAME=> 'Adam' )

To add a new contact named Bert, with a description:

call QUSRBRM.ADD_ENTERPRISE_CONTACT(

     CONTACT_USER_NAME=> 'Bert',

     DESCRIPTION=>'Bert from Accounting' )

call QUSRBRM.ADD_ENTERPRISE_CONTACT(

     CONTACT_USER_NAME=> 'Bert',

     DESCRIPTION=>'Bert from Accounting' )

To add a new contact named Chuck, with all fields populated:

call QUSRBRM.ADD_ENTERPRISE_CONTACT(

     CONTACT_USER_NAME=> 'Charlie',

     EMAIL_ADDRESS=> 'charlie@example.com',

     FIRST_NAME=> 'Charlie',

     LAST_NAME=> 'Roast',

     PRIMARY_PHONE=> '507-555-1212',

     SECONDARY_PHONE=> '612-555-1212',

     DESCRIPTION=> 'Chuck from IT' )

call QUSRBRM.ADD_ENTERPRISE_CONTACT(

     CONTACT_USER_NAME=> 'Charlie',

     EMAIL_ADDRESS=> 'charlie@example.com',

     FIRST_NAME=> 'Charlie',

     LAST_NAME=> 'Roast',

     PRIMARY_PHONE=> '507-555-1212',

     SECONDARY_PHONE=> '612-555-1212',

     DESCRIPTION=> 'Chuck from IT' )

Error Messages

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

U0001

Contact ID cannot be blank or null.

U0002

Contact ID already exists.

U0011

Unable to add Enterprise Contact.

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.