Contents Index Adding or deleting scripts Writing scripts to upload rows

MobiLink Synchronization User's Guide
  Writing Synchronization Scripts
    Adding and deleting scripts in your consolidated database

Direct inserts of scripts


In most cases, 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, older versions of some DBMSs may have length limitations that make it difficult to use stored procedures.

For a complete description of the MobiLink system tables, see MobiLink 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:

Consolidated database Setup file
Adaptive Server Anywhere scripts\syncasa.sql
Oracle MobiLink\setup\syncora.sql
IBM DB2 version 6 and later MobiLink\setup\syncdb2long.sql
IBM DB2 prior to version 6 MobiLink\setup\syncdb2.sql
Microsoft SQL Server MobiLink\setup\syncmss.sql
Adaptive Server Enterprise version 12.5 and later MobiLink\setup\syncase125.sql
Adaptive Server Enterprise prior to version 12.5 MobiLink\setup\syncase.sql

Note: IBM DB2 prior to version 6 only supports column names and other identifiers of 18 characters or less, and so the names are truncated. For example, ml_add_connection_script is shortened to ml_add_connection_.


Contents Index Adding or deleting scripts Writing scripts to upload rows