by Our company has a product written in a Pick-like database product
that has an interface to the Sybase DBLIBS/NETLIBS suite. One of our
customers has a need to make both ad-hoc and pre-defined SQL queries of
our database from a product they intend to purchase. The product they
intend to purchase is available under both Oracle and Ingres. My questions
to all you Oracle/Ingres literate people are: (1) What facilities exist
within Oracle/Ingres to facilitate SQL queries via the Sybase interface?
(2) Do such facilities require the purchase of extra Oracle/Ingres modules
or perhaps third party products? (3) How do these facilities handle non
standard extensions to the syntax of SQL statements - we need some added
clauses to guarantee that the returned tables are viewed as fully normalised
by Oracle/Ingres.
Thanks in advance,