Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » MobiLink - Server Administration » MobiLink Server System Tables

ml_database Next Page


This table is used only for server-initiated synchronization. It stores device names that are required by device tracking.




VARCHAR(255). Primary key. This column stores the name given to the device. This name is extracted from the operating system unless you specify a name using the dblsn -e option.


VARCHAR(128). Not null. This column contains the SQL Anywhere version number for the installed software on the device. Changing this value does not affect the operation of the software, but may be useful for diagnostic purposes.


INTEGER. Not null. This column is 0, 1, or 2:

  • 0 - for Listeners from SQL Anywhere prior to version 9.0.1
  • 1 - for post-9.0.0 Palm Listeners
  • 2 - for post-9.0.0 Windows Listeners
infoVARCHAR(255). Not null. This column stores operating system information about the listening device. This information can be overridden by providing information using the dblsn -f option.
ignore_trackingVARCHAR(1). Not null. If this is y, tracking information is not written to the row. If it is n, tracking information is written to the row.
sourceVARCHAR(255). Not null. 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. See Using device tracking with Listeners that don't support it.

If you want to stop automatic tracking, set ignore_tracking to y. In this case, it is also recommended that you use a source name other than tracking.

See also