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

SQL Anywhere 12.0.0 » MobiLink - Server Administration » MobiLink events » Writing synchronization scripts » Writing scripts to download rows


Writing download_cursor scripts

You write download_cursor scripts to download rows from the consolidated database to your remote database. Similarly, you write download_delete_cursor scripts to download rows to delete from the remote database. You must write both of these scripts for each table in the remote database for which you want to download changes. You can use other scripts to customize the download process, but no others are necessary.

  • Each download_cursor script that you want to download rows must contain a SELECT statement or a call to a procedure that contains a SELECT statement.

  • If you do not want download rows, define the script as --{ml_ignore}. Alternatively, you can use the ml_add_missing_dnld_scripts system procedure to define missing download scripts as ignored. See ml_add_missing_dnld_scripts system procedure.

  • The download_cursor script must select all columns that correspond to the columns in the corresponding table in the remote database. The columns in the consolidated database can have different names than the corresponding columns in the remote database, but they must be of compatible types.

 See also