UPDATE CONTACT command using the ADMIN_CMD procedure

The UPDATE CONTACT command updates the attributes of a contact that is defined on the local system. A contact is a user to whom the Scheduler and Health Monitor send messages.

To create a contact, use the ADD CONTACT command. The setting of the Database Administration Server (DAS) contact_host configuration parameter determines whether the list is local or global.

Authorization

None

Required connection

Database. The DAS must be running.

Command syntax

Read syntax diagramSkip visual syntax diagramUPDATE CONTACTnameUSING,keywordvalue

Command parameters

UPDATE CONTACT name
The name of the contact that will be updated.
USING keyword value
Specifies the contact parameter to be updated (keyword) and the value to which it will be set (value). The valid set of keywords is:
ADDRESS
The email address that is used by the SMTP server to send the notification.
TYPE
Whether the address is for an email address or a pager.
MAXPAGELEN
The maximum number of characters that the pager can accept.
DESCRIPTION
A textual description of the contact. This has a maximum length of 128 characters.

Example

Update the address of user 'test' to 'newaddress@test.com'. 
CALL SYSPROC.ADMIN_CMD( 'update contact test using address newaddress@test.com' )

Usage notes

The DAS must have been created and be running.

Command execution status is returned in the SQLCA resulting from the CALL statement.