MobiLink Server-Initiated Synchronization User's Guide
Server-Initiated Synchronization Stored Procedures
Use this stored 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.
| 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 notification. |
| 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. |
The stored 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.
For more information, see Using device tracking with Listeners that don't support it.
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' );
SQL Anywhere Studio 9.0.2
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.