Deprecated. Use subscription_n instead. The publications being synchronized, where n is an integer. There is one publication_n entry for each publication being synchronized. 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.
The names of subscriptions being synchronized where n is an integer. This is one subscription_n entry for each subscription being synchronized. The numbering of n starts at zero.
The following logs the end of the download for each synchronization.
CREATE PROCEDURE sp_hook_dbmlsync_download_end ()
DECLARE subs_list VARCHAR(1024);
-- build a list of subscriptions being synchronized
SELECT LIST(value) INTO subs_list
WHERE name LIKE 'subscription_%';
-- log the event
INSERT INTO SyncLog(event_time, event_name, subs)
VALUES( CURRENT TIMESTAMP, 'sp_hook_dbmlsync_download_end', subs_list );