MobiLink Synchronization Reference
Stored Procedures
Stored procedures to add or delete scripts
Use this stored procedure to add or delete SQL table scripts in the consolidated database.
| Item | Parameter | Description |
|---|---|---|
| 1 | version | VARCHAR(128) |
| 2 | table_name | VARCHAR(128) |
| 3 | event | VARCHAR(128) |
| 4 | 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 table 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 table, 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 command adds a cursor script associated with the upload_cursor event on the ULCustomer table.
call ml_add_table_script( 'custdb',
'ULCustomer',
'upload_cursor',
'SELECT cust_id, cust_name
FROM ULCustomer WHERE cust_id = ?' )