Follow these guidelines to query data without native classes.
- Configure ASE/CIS with a remote server
and proxy to connect via DirectConnect. For example, use DirectConnect
for Oracle to the Oracle server.
- Configure SAP Sybase IQ with a remote server using the
ASEJDBC class to the Adaptive Server server. (The ASEODBC
class is unavailable because there is no 64-bit Unix ODBC driver for
Adaptive Server.)
- Use the CREATE EXISTING TABLE statement
to create proxy tables pointing to the proxy tables in ASE which
in turn point to Oracle.