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.

Hook procedures can be created by any user with the MANAGE REPLICATION system privilege. However, to ensure that the hook can access the #hook_dict table, which is used to pass information in and out of hooks, hooks must meet one of the following requirements:

• Synchronization event hook sequence
• MobiLink SQL Anywhere client extended options
• Priority order

The following example uses sp_hook_dbmlsync_set_extended_options to specify the Increment 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 Increment extended option
   UPDATE #hook_dict
          SET value = 'Increment=10K'
    WHERE name = 'extended options'; 
 END IF;
END;