Re: Distributed Join

Hi Dave Drago, Yes, this is new functionality in OmniSQL Gateway. Francisco In <3rmus7$h4s@inet-nntp-gw-1.us.oracle.com> ddargo@us.oracle.com (Dave Dargo) writes: > >fcasas@ix.netcom.com (Francisco Casas) writes: > >>Ingres who? Why limit yourself to Ingres when most large companies run >>their business on at least 5 different databases. Those databases >>generally include DB2, Oracle, Sybase, some flat files and hierarchical >>databases. Sybase's OmniSQL Gateway let's you access most of these >>databases transparently in a heterogenous environment. >> >>Did I also mention that we can do perform transparent two-phase commit >>to in a heterogenous DBMS environment. >> > >Since when? Last I heard Sybase couldn't do a transparent recoverable >two phase commit between to Sybase databases (it requires a significant >amount of programming). Has OmniSQL Gateway come out with new functionality? >Do you really mean two place commit, i.e. you commit in one place and if it >works you then commit in the other? This is how the product use to work and >can NOT be called two phase commit as it is not recoverable. > >Oracle's Transparent Gateway products do support recoverable two phase commit >between Oracle and non Oracle databases, with no programming (i.e. it's >transparent). > >Dave Dargo (ddargo@us.oracle.com)