|
Home > Archive > SQL Anywhere database > August 2005 > Again: Can a trigger update a table in other database?
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 |
Again: Can a trigger update a table in other database?
|
|
| Renato Cramer 2005-08-25, 7:23 am |
| Hello,
There is on SQL Anywhere 5.5.04 User's Guide a chapter:
"Coordinating transactions with multiple database engines".
Also, there is reference to two-phase commit algorithm to
coordinate transactions across multiple database servers.
Is the SA 5 User's Guide wrong?
What version implement this feature?
I'm confused.
Please, can someone explain me?
Thanks in advance,
Cramer.
[color=darkred]
> This is not possible in SA 5. This ability to access
> another database was introduced after SA5.
>
> <Renato Cramer> wrote in message
| |
| Dmitri 2005-08-25, 7:23 am |
| Renato Cramer wrote:
> There is on SQL Anywhere 5.5.04 User's Guide a chapter:
> "Coordinating transactions with multiple database engines".
> Also, there is reference to two-phase commit algorithm to
> coordinate transactions across multiple database servers.
>
> Is the SA 5 User's Guide wrong?
No. But the feature you need (that is, possibility to access another
database from within your database) has been introduced in ASA6 and has
nothing to do with the part of manual you quote. Bottom line: you need
ASA6+. SA 5.5 is a very reliable software, but it doesn't have some
advanced features.
Dmitri.
| |
| Renato Cramer 2005-08-25, 7:23 am |
| Dmitri,
Thank you very much.
Renato Cramer.
> Renato Cramer wrote:
>
>
> No. But the feature you need (that is, possibility to
> access another database from within your database) has
> been introduced in ASA6 and has nothing to do with the
> part of manual you quote. Bottom line: you need ASA6+. SA
> 5.5 is a very reliable software, but it doesn't have some
> advanced features.
>
> Dmitri.
|
|
|
|
|