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.

IBM Partnership

QUSRBRM.ADD_ENTERPRISE_CONTACT Procedure

Parameters

Examples:

Error Messages