Querying Data Without Native Classes

Follow these guidelines to query data without native classes.

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