Hi,

>> Well, first question - how does it look from SQL standard POV? With
> slightly
>> modified (avoid '@' in favour of '.') Vlad's suggestion we are getting
> quite
>> close to it: <schema name>.<table name>. On the other hand I do not see
>
> In my opinion, schema.table is different from table@datasource and it should
> be.
>
> The "at datasource" kinda makes sense to me, from a developer pov and
> clearly
> distinguishes between a local table and a remote table.

I don?t see problems using de dot '.' and i think it's more "conform" the SQL standard. The SQL standard talks about
identifier chain for certain objects and this would fit to IMO.

<identifier chain> ::=
<identifier> [ { <period> <identifier> }... ]

Yes, we don't have schema's/catalogs at the moment, but we can take this into account.

<relation name> ::=
[ <schema name> <period> ] <qualified identifier>

<schema name> ::=
[ <catalog name> <period> ] <identifier>

<catalog name> ::=
[ <datasource name> <period> ] <identifier>


SELECT
*
FROM
<datasource name>.<catalog name>.<schema name>.<relation name>

SELECT
*
FROM
MyAddedDS...TableX

or just support both "..." and "@" ;)

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database with many powerful SQL features:
http://www.firebirdsql.org
http://www.firebirdsql.info

General database developer support:
http://www.databasedevelopmentforum.com

Support list for Interbase and Firebird users:
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep:
news://newsgroups.firebirdsql.info