|
Home > Archive > Sybase Database > March 2006 > RealTimeDataServices question...
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
RealTimeDataServices question...
|
|
| badbrownie@gmail.com 2006-03-08, 8:23 pm |
| I'm reading up on this topic as I need to be able to receive
information about db updates that occur in real time.
I see that I can receive messages via tibco or MQSeries regarding
updates. However, I can't tell whether I would receive all information
about db updates automatically or whether I would need to manually
specify what information is sent to my custom app via rep-connector
using msgsend or msgpublish.
Can anyone let me know whether I can use RTDS to automatically receive
messages regarding every update that happens in the Sysbase ASE?
thanks for your help.
alan
| |
| Rob Verschoor 2006-03-09, 8:23 pm |
| RTDS means that you can communicate with a message bus from SQL. This works
by calling T-SQL functions like msgsend() and msgrecv(). You have to code
these yourself -- if you want to have message sent for all updates, you
should create triggers and push messges onto the bus in the trigger.
HTH,
Rob
-------------------------------------------------------------
Rob Verschoor
Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase
Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"
mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------
<badbrownie@gmail.com> wrote in message
news:1141858296.493334.175800@e56g2000cwe.googlegroups.com...
> I'm reading up on this topic as I need to be able to receive
> information about db updates that occur in real time.
>
> I see that I can receive messages via tibco or MQSeries regarding
> updates. However, I can't tell whether I would receive all information
> about db updates automatically or whether I would need to manually
> specify what information is sent to my custom app via rep-connector
> using msgsend or msgpublish.
>
> Can anyone let me know whether I can use RTDS to automatically receive
> messages regarding every update that happens in the Sysbase ASE?
>
> thanks for your help.
>
> alan
>
| |
| badbrownie@gmail.com 2006-03-10, 11:23 am |
| Thanks for the info Rob,
In Oracle, all this information (all updates and inserts on the
database) is contained in the Redo logs. Is there any equivalent in
Sybase?
I was hoping there would be some way that replication server would give
me this info with no peturbation of the db code. It seems I was wrong
to hope that. Bummer.
alan
|
|
|
|
|