RE: SELECT QUERY between 2 different databases on the same server

This works to. We do this all the time. The only thing we see in some rare cases, is that some querys are much slower if we run them from an other server. Doris -----Original Message----- From: Thiel Franky [mailto:franky.thiel@INFOHOS.BE] Sent: donderdag 15 juni 2000 16:50 To: 'Martin, Wayne E.' Cc: 'informix-list@iiug.org' Subject: RE: SELECT QUERY between 2 different databases on the same server Is it possible to do that if the two databases are not on the same server ? Regards, Franky -----Oorspronkelijk bericht----- Van: Martin, Wayne E. [mailto:WMartin@kmart.com] Verzonden: donderdag 15 juni 2000 15:22 Aan: 'mars1972@my-deja.com'; informix-list@iiug.org Onderwerp: RE: SELECT QUERY between 2 different databases on the same server Syntax should be: select * from database@informixserver:table_name wheredatabase@informixserver:table.column rel_op database@informixserver:table.column etc..... -----Original Message----- From: mars1972@my-deja.com [mailto:mars1972@my-deja.com] Sent: Wednesday, June 14, 2000 4:02 PM To: informix-list@iiug.org Subject: Re: SELECT QUERY between 2 differend databases on the same server Yes, if I remember right, just prepend the table names with the database name and a colon. For example: select <whatever> from sysmaster:systables, stores7:customer where... In article <3947CD4F.1205F902@ihs.com>, Richard Krenek <rkrenek@ihs.com> wrote: > Is it possible to do a query that touches 2 different tables in > different databases on the same server. Here is the SQL statment that > they want to use but they want the table doc_update to be in a different > database than doc_master. > > SQL INSERT INTO doc_update > (doc_global_id, fam_global_id, fam_num_gid, fam_sn, > source, kind, act_hist_ind, doc_key_date, pub_num, > rev_sn, sfx_sn, in_lieu_of, most_active, common_gid) > SELECT doc_global_id, fam_global_id, fam_num_gid, fam_sn, > source, kind, act_hist_ind, doc_key_date, pub_num, > rev_sn, sfx_sn, in_lieu_of, most_active, common_gid > FROM doc_master > WHERE act_hist_ind = 'A'> > Why we want to do this you ask!! Because I was asked to. We are > comparing times to do certain queries/inserts between 4 Databases > (OpenIngres/Informix/DB2/Oracle) We are using Informix 7.(forgot this > part). If we do choose Informix it will be replacing OpenIngres that has > its data spread accross 20 databases and they most likely want to copy > that structure to Informix and I need to know if that is possible (or > desirable). > > Thanks, > Richard Krenek > > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.