--- In firebird-support@yahoogroups.com, "cedric_maucourt"
<cedric.maucourt1@m...> wrote:

>
> Hello,
>
> First I apologize for my poor english... :)
>
> I would like to use the embedded version of Firebird server in order to
> do an application migration from WSAD/DB2 to Tomcat/free database
> server. Firebird seems to work fairly well but I encountered a
> problem : all the SQL queries in the application to migrate refer to
> tables with the syntax "database_name.table_name".
> Here's an example : INSERT INTO AFDZAC.FDZQTA01
> (CODE_LDP,CODE_REG,EXPR_LCDV) VALUES ...
> The problem is that for different reasons we cannot change the queries
> and Firebird seems to reject this syntax and accepts just the name of
> the table. This syntax works on DB2 (and MySQL too) and I wonder if
> there is a way to force Firebird to accept it too.

No

If you quoted the table names, you could probably create a table
called "AFDZAC.FDZQTA01", but then you would need to use the
quotations to refer to it.

>With aliases?

Well if you could use table name aliases (which is what I am assuming
you mean), then it would be just as easy to change the queries.

Adam