Re: Distributed Join

Hi Eoin, OmniSQL Gateway will indeed work with multiple databases at the same time. One may perform a distributed query between Sybase SQL Server, Oracle7, Informix, DB2, IMS, Adabas and others. In fact Omni can access any data source that Sybase or MDI has gateways for (which is quite a bit). If the customer decides to use a Sybase Open Server application Omni will access that Open Server application just as if it where any of the other mentioned data sources. In addition Omni allows application developers to write T-SQL (Sybase SQL Server's language) stored procedures against any data source. This means that a customer may have stored procedures against DB2 today! Indeed, about two years ago I almost won a bet with an Oracle employee that we, Sybase, were going to have stored procedures for the Oracle DBMS before Oracle Corporation (I lost by one week). In the upcomming version of Omni we will support transparent two-phase commit accross heterogenous environments. Francisco In <802275189snz@copse.demon.co.uk> Eoin Woods <Eoin@copse.demon.co.uk> writes: > >In article <MAL.95Jun3100013@yavanna> mal@winternet.com "Michael Leo" writes: >> You could just buy Ingres/Star and use normal everyday SQL, not knowing >> which table is on which node. You can do this from ANY tool, not just >> call-level or embedded C. You can do this from ANY third party tool >> that works against plain old Ingres. Ingres/Star deals with the >> "distriby" stuff behind the Ingres front-end. >> >> Granted the product is not perfect, but its been able to do this for >> the last 5 years, at least. >> >> One has to ask, "Why can't Sybase?" >Well actually, Sybase *can* ! The product to do this is OMNI and it supports >distributed joins across most data sources (including, I think, some >non relational ones). > >(Yes, I am a Sybase employee - I'm just posting from home). > >Eoin. >-- >Eoin Woods, Watford, Hertfordshire, WD1 1PD, UK >Email: Eoin@copse.demon.co.uk