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

SQL Anywhere 11.0.1 (Français) » MobiLink - Getting Started » Introducing MobiLink Technology » Exploring the CustDB sample for MobiLink » Synchronizing CustDB


Synchronizing products in the CustDB sample

Business rules

All rows are downloaded for ULProduct—this is called snapshot synchronization.

See Snapshot synchronization.

The business rules for the ULProduct table are as follows:

  • Products can only be modified at the consolidated database.

  • Each remote database contains all the products.


Product information can be inserted, deleted, or updated at the consolidated database. The script corresponding to these operations is as follows:

  • download_cursor   The following download_cursor script downloads all the rows and columns of the ULProduct table at each synchronization:
    SELECT prod_id, price, prod_name FROM ULProduct