MobiLink Synchronization Reference
Stored Procedures
Stored procedures to add or delete scripts
Use this stored procedure to add or delete SQL connection scripts in the consolidated database.
| Item | Parameter | Description |
|---|---|---|
| 1 | version | CHAR(128) |
| 2 | event | CHAR(128) |
| 3 | script | For Adaptive Server Anywhere and MS SQL Server, this is TEXT. For ASE, this is VARCHAR(16384). For ASE prior to 12.5, this is VARCHAR(255). For DB2, this is VARCHAR(4000). For Oracle, this is VARCHAR. |
To delete a connection script, set the script parameter to NULL.
When you add a script, the script is inserted into the ml_script table and the appropriate references are defined to associate the script with the event and script version that you specify. If the version name is new, it is automatically inserted into the ml_version table.
Adding and deleting scripts in your consolidated database
The following statement adds a connection script associated with the begin_synchronization event to the script version custdb in an Adaptive Server Anywhere consolidated database. The script itself is the single statement that sets the @EmployeeID variable.
call ml_add_connection_script( 'custdb', 'begin_synchronization', 'set @EmployeeID = ?' )