RE: IDS Next Version - features wanted.

Exists since a long time. Connects to Oracle (and even Sybase I think) via ODBC. Also there's a Gateway to connect via DRDA to DB2, even to DB2 on mainframe. And the latter one was even working via SNA, before DB2 on mainframe supported TCP/IP. You can connect your client directly to the Gateway, or you can have a co-ordinating IDS server do that (and let your clients connect to the IDS server). Using synonyms you can hide most of the "strange databases" from your application and things appear to them as if they were regular IDS databases and tables. (Some restrictions apply to "foreign" data types that are not mapped.) Regards, Martin -- Martin Fuerderer IBM Informix Development Munich, Germany Information Management "Dirk Moolman" <DirkM@mxo.co.za> wrote on 06/02/2005 02:12:34 PM: > > -----Original Message----- > From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] > On Behalf Of gsturkenboom@lic.co.nz > Sent: 02 June 2005 01:21 AM > To: Marco Greco > Cc: informix-list@iiug.org > Subject: Re: IDS Next Version - features wanted. > > [snip] > > > >Select a.*, b.*, c.* > >from <informix table> a, <oracle table> b, <db2 table> c > >where a.col3 = b.col1 > >and a.col4 = c.col1; > > > >Is this the Informix Enterprise Gateway product? If so I find it > >somewhat invasive on the external environment. > > Informix Enterprise Gateway ? Are you just joking, or does it really > exist ? Do they really have a product like Oracle's enterprise > gateway ? > > sending to informix-list sending to informix-list