--- In firebird-support@yahoogroups.com, Sam Hunt <shunt@n...> wrote:

> Gary Benade wrote:
> According to Helen's book, FB152 handles multi-database joins using
> 2-phase commits and explicit transactions.
> (What did I just say?!)

Where exactly did you read that?
If you have the same edition of the book like me, read also page 92
and 551 - that should make it more clear. I also first have been
stumbling about this, btw.

Firebird can NOT combine two databases by means of itself.
You need your client application to do that. In Helen's book, if you
read closely, there also are mentioned 'Firebird APPLICATIONS', not
the server system itself.

You can, basically, start one transaction to the server.
Within this transaction, you can make several operations concerning
different databases. The final commit() or rollback() decides, whether
the total of ALL operations in ALL affected databases are committed or
rolled back.

So, the support for multiple databases is restricted to transaction
control.

ciao,
André