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 ID cannot be blank or null. |
U0003 | Contact ID not found. |
U0012 | Unable to retrieve Enterprise Contact. |
U0014 | Unable to change Enterprise Contact. |
U9999 | Illegal execution. |