Re: how to select

Posted in 2001

Ifrim Sorin — Sat, 20 Jan 2001 15:01:55 +0200 — source: Informix-list mailing list archive (1991-1998)

The syntax should be something like select database1@name_of_instance1:table1, database2@name_of_instance2:table2 ... HTH Sorin Ifrim ----- Original Message ----- From: Jagdish <jaggi_informix@yahoo.com> To: <informix-list@iiug.org> Sent: Saturday, January 20, 2001 12:58 PM Subject: how to select > > Hai useres, > > I have 2 instance runing in my same machine. is't > possible to select the table from the other database > instance. kindly help me by providing the syntax. > > TIA > Jagdish > > __________________________________________________ > Do You Yahoo!? > Yahoo! Auctions - Buy the things you want at great prices. > http://auctions.yahoo.com/

↪ replying to Ifrim Sorin

Flavio Gattari — Mon, 22 Jan 2001 19:08:46 +0100 — source: Informix-list mailing list archive (1991-1998)

IN IDS2000 (9.21) THIS SYNTAX WORKS ONLY IF THE INVOLVED TABLES DO NOT CONTAIN ANY BLOB COLUMNS. Flavio Gattari Ifrim Sorin ha scritto nel messaggio <94c30u$54a$1@news.xmission.com>... > >The syntax should be something like > > select database1@name_of_instance1:table1, >database2@name_of_instance2:table2 ... > >HTH >Sorin Ifrim > >----- Original Message ----- >From: Jagdish <jaggi_informix@yahoo.com> >To: <informix-list@iiug.org> >Sent: Saturday, January 20, 2001 12:58 PM >Subject: how to select > > >> >> Hai useres, >> >> I have 2 instance runing in my same machine. is't >> possible to select the table from the other database >> instance. kindly help me by providing the syntax. >> >> TIA >> Jagdish >> >> __________________________________________________ >> Do You Yahoo!? >> Yahoo! Auctions - Buy the things you want at great prices. >> http://auctions.yahoo.com/ >