QUSRBRM.CHANGE_ENTERPRISE_CONTACT Procedure
- Peter Lafler
- Darren Hagenson
The QUSRBRM.CHANGE_ENTERPRISE_CONTACT procedure allows you to change the information for a contact to BRMS enterprise.
Parameters
|
contact-id (required)
Specifies the unique contact ID. Possible values are:
contact-id | Specifies the unique contact ID. The contact ID 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. The current value will be preserved. |
' ' | Remove the current value. |
email-address | Specifies the email address of the contact. |
Â
Â
first_name (optional)
Specifies the contact's first name. Possible values are:
NULL | The optional value has not been specified. The current value will be preserved. |
' ' | Remove the current value. |
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. The current value will be preserved. |
' ' | Remove the current value. |
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. The current value will be preserved. |
' ' | Remove the current value. |
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. The current value will be preserved. |
' ' | Remove the current value. |
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. The current value will be preserved. |
' ' | Remove the current value. |
description | Specifies a description for the contact. |
Â
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 email address for the contact named Adam:
call QUSRBRM.CHANGE_ENTERPRISE_CONTACT( Â Â Â CONTACT_USER_NAME=> 'Adam', Â Â Â EMAIL_ADDRESS=> 'adam@example.com' ) |
|---|
To change the First Name & Last Name for the contact named Bert:
call QUSRBRM.CHANGE_ENTERPRISE_CONTACT( Â Â Â CONTACT_USER_NAME=> 'Bert', Â Â Â FIRST_NAME=>'Bert', Â Â Â LAST_NAME=>'Smith' ) |
|---|
To remove the primary and secondary phone numbers for the contact named Charlie:
call QUSRBRM.CHANGE_ENTERPRISE_CONTACT( Â Â Â CONTACT_USER_NAME=> 'Charlie', Â Â Â PRIMARY_PHONE=>'', Â Â Â SECONDARY_PHONE=>'' )Â |
|---|
call QUSRBRM.CHANGE_ENTERPRISE_CONTACT( Â Â Â CONTACT_USER_NAME=> 'Charlie', Â Â Â PRIMARY_PHONE=>'', Â Â Â SECONDARY_PHONE=>'' )Â |
|---|
Error Messages
The following SQL States and error messages may be returned by this procedure.
U0001 | Contact user name not valid. |
U0003 | Contact not found. |
U0012 | Unable to retrieve Enterprise Contact. |
U0014 | Unable to change 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.