The QUSRBRM.ENTERPRISE_CONTACT_INFO view shows the settings for an enterprise node. Contacts are users associated with the enterprise hub and nodes. The contacts are used for a variety of notifications including reports or errors encountered while generating reports.

Authorization:

The authorization ID of the statement must include the following privileges:

*OBJOPR and *READ authority to the QUSRBRM/CONT_INFO object.

Result Table

The following table describes the columns in the view. The system name is CONT_INFO. The schema is QUSRBRM.

Column Name	System Column Name	Data Type	Description
CONTACT_USER_NAME	CONTACT	VARCHAR(10)	The contact user name.
FIRST_NAME	FIRST_NAME	VARGRAPHIC(20) CCSID 1200 Nullable	The first name of the contact. Contains the null value if the contact first name is not set.
LAST_NAME	LAST_NAME	VARGRAPHIC(40) CCSID 1200 Nullable	The last name of the contact. Contains the null value if the contact last name is not set.
TEXT_DESCRIPTION	TEXT	VARGRAPHIC(128) CCSID 1200 Nullable	The text description of the contact. Contains the null value if the text description is not set.
PRIMARY_PHONE_NUMBER	PRIMARY	VARCHAR(26) Nullable	The primary phone number of the contact. Contains the null value if the primary phone number is not set.
SECONDARY_PHONE_NUMBER	SECONDARY	VARCHAR(26) Nullable	The secondary phone number of the contact. Contains the null value if the secondary phone number is not set.
EMAIL_ADDRESS	EMAILADDR	VARGRAPHIC(128) CCSID 1200 Nullable	The email address of the contact. Contains the null value if the email address is not set.

Example

Example 1: Report contact information for contact user name ADMIN

SELECT CONTACT_USER_NAME, FIRST_NAME, LAST_NAME, EMAIL_ADDRESS FROM QUSRBRM.ENTERPRISE_CONTACT_INFO WHERE CONTACT_USER_NAME = 'ADMIN'

Example output:

CONTACT_USER_NAME	FIRST_NAME	LAST_NAME	EMAIL_ADDRESS
ADMIN	JOHN	DOE	mailto:JOHN.DOE@EXAMPLE.COM

IBM Partnership

QUSRBRM.ENTERPRISE_CONTACT_INFO View

Example

Example 1: Report contact information for contact user name ADMIN