This table is used only for server-initiated synchronization. It stores addressing information that is required by device tracking.
| Column | Description |
|---|---|
| device_name | VARCHAR(255). Primary key. Foreign key references dbo.ml_device. Not null. |
| medium | VARCHAR(255). Primary key. Not null. |
| address | VARCHAR(255). Not null. |
| active | CHAR(1). Not null. |
| last_modified | Timestamp. Not null. Default timestamp. |
| ignore_tracking | CHAR(1). Not null. |
| source | VARCHAR(255). Not null. |
device_name A name given to the device. This name is extracted from the operating system unless you specify a name using the dblsn -e option.
medium For UDP, this is _UDP_. Otherwise, it is the network provider ID.
address For UDP, this is ip:port-number, where ip is an IP address or host name. For SMTP, this is the phone number.
active This is y for active, and n otherwise. A DeviceTracker gateway may deactivate a UDP channel if it is unresponsive and there is a fallback SMTP delivery path.
last_modified This tells when this row was last modified.
ignore_tracking If this is y, tracking information is not written to the row. If it is n, tracking information is written to the row.
source This is tracking if the row was created by automatic device tracking. Otherwise, it is blank unless you change it using stored procedures to add information about where the data in this row came from. Unless it is set to tracking, the value in this column does not affect the operation of the software.
The MobiLink system tables ml_device, ml_device_address, and ml_listening contain information about devices for server-initiated synchronization. DeviceTracker gateways use this information to address target devices by MobiLink user name.
In most cases, you should not need to alter these tables. However, if your device does not support device tracking or if you want to override device tracking for troubleshooting purposes, you can add or delete rows to this system table using pre-defined stored procedures. For more information, see Using device tracking with Listeners that don't support it.
If you want to stop automatic tracking, set override_tracking to y. In this case, it is also recommended that you use a source name other than tracking. For more information, see ml_set_device_address.
SQL Anywhere Studio 9.0.2
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.