ml_set_device_address system procedure

Use this system procedure to add or alter information about remote device addresses when you are manually setting up device tracking. It adds or updates a row in the ml_device_address table.

Parameters

Item	Parameter	Description
1	device	VARCHAR(255). Existing device name.
2	medium	VARCHAR(255). Network provider ID (must match a carrier's network_provider_id property).
3	address	VARCHAR(255). Phone number of an SMS-capable device.
4	active	CHAR(1). Set to y to activate this record to be used for sending push notifications.
5	ignore_tracking	CHAR(1). Set to y to ignore tracking and stop it from overwriting manually entered data.
6	source	VARCHAR(255). Optional remarks on the source of this record.

Remarks

The system procedures ml_set_device, ml_set_device_address, and ml_set_listening are used to override automatic device tracking by changing information in the MobiLink system tables ml_device, ml_device_address, and ml_listening. For example, if some of your remote devices are Palms you may want to use automatic device tracking, but manually insert data for the Palm devices.

This system procedure is useful only if you are manually setting up device tracking. See Adding support for device tracking.

For DB2 mainframe consolidated databases, this procedure is called ml_set_dev_addr. See IBM DB2 mainframe server-initiated synchronization system procedure name conversions.

Example

For each device, add an address record for a device:

CALL ml_set_device_address(
    'myFirstTreo180', 
    'ROGERS AT&T', 
    '3211234567',
    'y', 
    'y',
    'manually entered by administrator'
);

Discuss this page in DocCommentXchange.
Send feedback about this page using email.