Hi Pascal,
usually you can not query more than one database with one sql.
But really you don't query a database with a sql-statement, you do query a
table in a database to which you are
connected to.
And here lies the key, as far as your database does not support federated
database ( sql-access to remote databases), as e.g. DB2 does!
If your db does support the federate thing come back to me!
Even if it supports this thing, it may be easier to do the following, for
sure if you are the only one to have this problem.
You will have to construct a loop ( e.g. in perl )
* which does the connect to each of your 100 db's
* and then calls your sql-select
* and stores the result from that db e.g. in a hash
Best regards
Mit freundlichen Gr��en
Manfred Beilfuss
Deutsche Verm�gensberatung AG
IT-Systemmanagement / DBA
M�nchener Stra�e 1
60329 Frankfurt
Tel.: +49 (69) 2384 - 639
Mailto:[EMAIL PROTECTED]
"Pascal
Gravot" An: <[EMAIL PROTECTED]>
<[EMAIL PROTECTED] Kopie:
osion.com> Thema: sql problem
19.06.2003
02:50
Hi
Sorry I saw you comment on sql and I have a small problem that I cannot
resolve
Is it possible to query mutiple databases with one sql statement?
I'd like to query around 100 database and I'm interesting by only one
table (same name on all of the 100 databases) and inside of the table I
want only 3 fields
I have 100 databases
1 table on each call table_name
and the field field1, field2, field3(same for all
databases)
Could you help me on this
Thanks for u time
Best regards
Pascal Gravot
Guatemala
