QUSRBRM.ADD_ENTERPRISE_CONTACT Procedure
The QUSRBRM.ADD_ENTERPRISE_CONTACT procedure adds a contact to BRMS enterprise.
Parameters
|
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' ) |
---|
To add a new contact named Bert, with a description:
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' ) |
---|
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.