The following steps provide an overview of the tasks required to set up scripted upload, assuming that you already have MobiLink synchronization set up.
Create stored procedures that identify the rows to upload. You can define three stored procedures per table: one each for upload, insert, and delete.
Create a publication that contains the keywords WITH SCRIPTED UPLOAD and that specifies the names of the stored procedures.
When using scripted upload, it is strongly recommended that you use the default setting for the dbmlsync extended option LockTables.
You can avoid many problems with scripted uploads by using the default setting for LockTables, which causes dbmlsync to obtain locks on all synchronization tables before the upload is built. This prevents other connections from changing the synchronization tables while your scripts are building the upload. It also ensures that there are no uncommitted transactions that affect synchronization tables open while your scripts are building the upload.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|