Subject Re: [ib-support] Multy database ?
Author Fabricio Araujo
On Mon, 05 Mar 2001 11:10:07 -0500, Ann W. Harrison wrote:

>At 06:25 AM 3/5/2001 -0300, Fabricio Araujo wrote:
>>A transaction can be opened and oper with 2 DB connections, but only on
>>client side.
>>But SQL only understands commands regarding current database.
>Actually, an InterBase multi-database transaction is server side,
>for what little that's worth.

Oh... I forgot this "little" detail, after years lurking these lists... ;-)))

>You are quite correct that our
>SQL implementation gives no access to multi-database operations
>and that is a problem.

IB/Firebird or whatever it calls ;-)) is made in a way the
client must know where the DB is.
If we have aliasing, and make the alterations on our "beloved"
optimizer and query processor, cross-DB is possible.
Actually (via SQL - not QLI, GDML, etc) we not even have a
way to NAME this cross-db attach. SELECT blablabla from "server:/ibpath/ibdb.gdb". TABLE
is a real pain even thinking about it...

[]s Fabricio
Systems Developer