Subject Re: [firebird-support] Table references in SQL queries
Author Fabricio Araujo
SQL queries that reference more than one DB
is not supported by FB server.
Seems you'll have to erase the references to
another db...
Let's see if more knowlegeable people (Arno?
Ann? Helen?) have some idea...

On Thu, 13 Oct 2005 09:06:00 -0000, cedric_maucourt 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. With aliases? Or
>another trick?
>
>Thanks for your help.
>
>C├ędric
>
>
>
>
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>---
>avast! Antivirus: Inbound message clean.
>Virus Database (VPS): 0541-3, 14/10/2005
>Tested on: 16/10/2005 05:35:16
>avast! - copyright (c) 1988-2005 ALWIL Software.
>http://www.avast.com
>
>
>