Use this stored procedure to add custom actions at the end of the download stage of the synchronization process.
Name |
Value |
Description |
---|---|---|
publication_n (in) |
publication |
The publications being synchronized, where n is an integer. There is one publication_n entry for each publication being uploaded. The numbering of n starts at zero. |
MobiLink user (in) |
MobiLink user name |
The MobiLink user for which you are synchronizing. |
script version (in) |
script version name |
The MobiLink script version to be used for the synchronization. |
If a procedure of this name exists, it is called at the end of the download stage of the synchronization process.
Actions of this procedure are committed or rolled back when the download is committed or rolled back.
Assume you use the following table to log synchronization events on the remote database.
CREATE TABLE SyncLog ( "event_id" INTEGER NOT NULL DEFAULT AUTOINCREMENT , "event_name" VARCHAR(128) NOT NULL , "ml_user" VARCHAR(128) NULL , "event_time" TIMESTAMP NULL, "table_name" VARCHAR(128) NULL , "upsert_count" VARCHAR(128) NULL , "delete_count" VARCHAR(128) NULL , "exit_code" INTEGER NULL , "status_retval" VARCHAR(128) NULL , "pubs" VARCHAR(128) NULL , "sync_descr " VARCHAR(128) NULL , PRIMARY KEY ("event_id"), ) |
The following example compiles a list of publications. It logs the list of publications and other synchronization information at the end of the download stage of a synchronization.
CREATE PROCEDURE sp_hook_dbmlsync_download_end () BEGIN DECLARE pubs_list VARCHAR(1024); DECLARE temp_str VARCHAR(128); DECLARE qry VARCHAR(128); -- insert publication list into pubs_list SELECT LIST(value) INTO pubs_list FROM #hook_dict WHERE name LIKE 'publication_%'; -- log publication and synchronization information INSERT INTO SyncLog(event_name,ml_user,pubs,event_time) SELECT 'dbmlsync_download_end',#hook_dict.value, pubs_list,CURRENT TIMESTAMP FROM #hook_dict WHERE name='MobiLink user'; END |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |