SQL Anywhere Mobile - how to get the records downloaded (update/insert) to a table in

Author

how to get the records downloaded (update/insert) to a table in

vsv

2005-11-01, 8:48 pm

Requirement:
I want to obtain the list of all records that are being downloaded (update/insert) into a table & process
those records to populate other table in remote only.

env: asa 9.0.2.2451 remote db
ase 12.5.1 consolidated

I am trying to accomplish this using the last download time.

How to get the prior download time in the remote DB in sp_hook_dbmlsync_dow
nload_end & sp_hook_dbmlsync_dow
nload_table_end ?

The last download time from this query that I use

select last_download_time from
SYS. SYSSYNCSUBSCRIPTIONS
where
publication_name = 'pub_remote_page'
(Is there a system function to get this? )
gives the current download time & not the last download time during a synchronization process in the sp_hook_dbmlsync_dow
nload_end & sp_hook_dbmlsync_dow
nload_table_end event.

However, sp_hook_dbmlsync_dow
nload_begin does gives the last_download_time.

As of now the alternative i have is to store the value in a user temporary table during sp_hook_download_beg
in event.
But I would like to avoid doing that.

Thanks in advance
vsv

Sponsored Links