SQL Anywhere Mobile - Call SP on Remote during Sync

Author

Call SP on Remote during Sync

Donna Osburn

2005-08-23, 11:24 am

I know how to call an SP on the Consolidated during the
sync. Is there a way to call an SP on the remote during the
sync?

I have two publications on the remote. I have an sp on the
remote which erases data on the hand held. I need to call
it after the first publication syncs and before the second
publication syncs. I "could" call dbmlsync twice (once for
each pub) and let the app call the sp in the middle - but
that would not be graceful. is there a way to call the sp
on the remote during the sync? I would need to do it in the
end upload event or a similar event. i am actually already
using end upload to call a consolidated stored procedure.

Thanks
Donna

Shuchit

2005-08-23, 8:25 pm

Donna Osburn wrote in news:430b447f.1018.1681692777@sybase.com:

> I know how to call an SP on the Consolidated during the
> sync. Is there a way to call an SP on the remote during the
> sync?
>
> I have two publications on the remote. I have an sp on the
> remote which erases data on the hand held. I need to call
> it after the first publication syncs and before the second
> publication syncs. I "could" call dbmlsync twice (once for
> each pub) and let the app call the sp in the middle - but
> that would not be graceful. is there a way to call the sp
> on the remote during the sync? I would need to do it in the
> end upload event or a similar event. i am actually already
> using end upload to call a consolidated stored procedure.

You are looking for Synchronization hooks which are executed on the remote
database.
sp_hook_dbmlsync_upl
oad_end is called at the end of the upload phase.

Shuchit

Sponsored Links