MobiLink Synchronization Reference
Stored Procedures
Stored procedures to add or delete scripts
Use this stored procedure to add or delete .NET table scripts in the consolidated database.
| Item | Parameter | Description |
|---|---|---|
| 1 | version | VARCHAR(128) |
| 2 | table | 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 connection script, set the script parameter to NULL.
The script value is a public method in a class in the MobiLink synchronization server classpath (for example, MyClass.MyMethod).
When you add a script, the method is associated 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 example assigns the empDownloadCursor method of the EgClass class to the download_cursor event for the table emp.
call ml_add_dnet_table_script( 'ver1', 'emp', 'download_cursor',EgPackage.EgClass.empDownloadCursor')