Hi all,

In some DBMSs that I have used, I am able to refer to a database outside of
the current db.

For example, in Sybase, if I have a DB for accounts (DBACCOUNTS) and a db
for Clients (DBCLIENTS), I am able to make cross references.

Say that the DBCLIENTS db has a CLIENTDETAILS table, and the DBACCOUNTS db
has a TRANSACTIONS table. I am able to do the following (assuming a common
field "ACCOUNTNUMBER", and that I am making the call from the DBACCOUNTS db)

SELECT C.CLIENTNAME, T.AMOUNT FROM DBCLIENTS.CLIENTDETAILS, TRANSACTIONS T
where C.ACCOUNTNUMBER = T.ACCOUNTNUMBER.

I am also able to access views, stored procedures, etc in the "external"
database. I could say EXECUTE PROCEDURE DBCLIENTS.UPDATECLIENTDETAILS
(parameters etc), assuming such a stored procedure existed in the
"external" database.

Is it possible to do something similar in FB / IB?

thanks

Tim


[Non-text portions of this message have been removed]