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

SAP Sybase SQL Anywhere 16.0 » MobiLink - Server Administration » MobiLink events » Synchronization script writing » Script additions and deletions


Direct inserts of scripts

It is recommended that you use stored procedures or Sybase Central to insert scripts into the system tables. However, in some rare cases you may need to use an INSERT statement to directly insert the scripts. For example, versions of some RDBMSs may have length limitations that make it difficult to use stored procedures.

For information about the MobiLink system tables, see MobiLink server system tables.

The format of the INSERT statements that are required to directly insert scripts can be found in the source code for the ml_add_connection_script and ml_add_table_script stored procedures. The source code for these stored procedures is located in the MobiLink setup scripts. There is a different setup script for each supported RDBMS. The setup scripts are all located in %SQLANY16%\MobiLink\Setup and are called:

Consolidated database Setup file
Adaptive Server Enterprise syncase.sql
IBM DB2 LUW syncdb2.sql
Microsoft SQL Server syncmss.sql
MySQL syncmys.sql
Oracle syncora.sql
SQL Anywhere syncsa.sql