>This is not a bug... Firebird doesn't have this feature... You can
>do this in Oracle, but not in Firebird. Well, for now you can't... Who knows
>the future!!!

That would probably explain it then, i.e. I didn't have time to actually test
it. This would mean implementing the SQL syntax described so gpre understands it...

Have you tried to do a similar operation using gdml rather than SQL?

e.g. instead of
INSERT INTO db2.TEST SELECT * FROM db1.TEST;
use something like

for a in db1.test
store b in db2.test
end_store
end_for



Paul