|
Home > Archive > SQL Anywhere database > August 2005 > 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 |
Can a trigger update a table in other database?
|
|
| Renato Cramer 2005-08-23, 8:23 pm |
| Hello,
I use SQL Anywhere 5.5.04 Build #1867.
Supposing two databases, A and B:
Is possible fire a trigger on database A and this update a
table on database B?
I didn't find orientation on documentation, only on ASA
7.0.2.
Is possible on 5.5.04?
Thanks in Advance,
Cramer.
| |
| Chris Keating \(iAnywhere Solutions\) 2005-08-23, 8:23 pm |
| This is not possible in SA 5. This ability to access another database was
introduced after SA5.
<Renato Cramer> wrote in message news:430b7c8b.1398.1681692777@sybase.com...
> Hello,
>
> I use SQL Anywhere 5.5.04 Build #1867.
>
> Supposing two databases, A and B:
> Is possible fire a trigger on database A and this update a
> table on database B?
>
> I didn't find orientation on documentation, only on ASA
> 7.0.2.
> Is possible on 5.5.04?
>
> Thanks in Advance,
> Cramer.
| |
| Renato Cramer 2005-08-23, 8:23 pm |
| Thanks Chris.
But, 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.
I'm confused.
Please, can you explain me?
Thanks again,
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
|
|
|
|
|