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.