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. |
U9999 | Illegal execution. |