Von Firebird zu Firebird-Database geht über eine Stored-Procedure:
Zitat:
Firebird 2.5 introduces a way to
query the external data sources in PSQL. EXECUTE STATEMENT has been extended with a special clause: ON EXTERNAL DATA SOURCE, and you can supply a different Firebird database as a data source. This means that you can fetch data from another database into PSQL variables. You cannot do JOINs with tables in different databases, but this is a nice start. Example:
execute block returns (emp_no smallint) as
begin
FOR EXECUTE STATEMENT 'select emp_no from employee'
ON EXTERNAL DATA SOURCE '
localhost:employee' AS USER 'sysdba' PASSWORD 'masterkey'
INTO :emp_no
DO SUSPEND;
end
As you can see, using aliases becomes important and there is still a lot to be desired, but it's enough to cover some of the most basic needs.
Grüße in die Runde