Use this stored procedure to programmatically customize the behavior of an upcoming synchronization by specifying extended options to be applied to that synchronization.
Name | Value | Description |
---|---|---|
publication_n (in) |
publication |
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. |
extended options (out) |
opt=val;... |
Extended options to add for the next synchronization. |
subscription_n (in) | subscription name(s) | 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. |
If a procedure of this name exists, it is called one or more times before each synchronization.
Extended options specified by this hook apply only to the synchronization identified by the subscription and MobiLink user entries, and they apply only until the next time the hook is called for the same synchronization.
The Schedule extended option may not be specified using this hook.
Actions of this procedure are committed immediately after execution.
The following example uses sp_hook_dbmlsync_set_extended_options to specify the SendColumnNames extended option. The extended option is only applied if sub1 is synchronizing.
CREATE PROCEDURE sp_hook_dbmlsync_set_extended_options () BEGIN IF exists(SELECT * FROM #hook_dict WHERE name LIKE 'subscription_%' AND value='sub1') THEN -- specify the SendColumnNames=on extended option UPDATE #hook_dict SET value = 'SendColumnNames=on' WHERE name = 'extended options'; END IF; END; |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |