Re: Outer join in database link query to Sybase

Vince wrote:
> I have a need to query records from a Sybase database running on Linux
> (32-bit) and am using Oracle 10.2.0.3 with generic connectivity (no
> specific heterogeneous service for Sybase on Linux). We have installed
> an ODBC driver on the Oracle server and can query the Sybase database
> without difficulty except for outer joins.
>
> I have tried using both the Oracle syntax and the ANSI syntax. Both
> return results that are consistent with using an inner join. The ANSI
> query, run directly against the Sybase database returns the correct
> data.
>
> I was looking into the possibility of using dbms_hs_passthrough, but
> it does not appear to be part of the generic connectivity.
>
> Is there a better/right way of doing this?
>
> Thanks,
> Vince

Build a view in Sybase that does what you want.

SELECT * from the view.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org