passthrough Mode

passthrough mode allows an ECDA Option for Oracle client to interact directly with an Oracle database using native Oracle SQL.

When ECDA Option for Oracle is operating as a standalone gateway, clients are automatically put into passthrough mode. When used with Adaptive Server, ECDA Option for Oracle performs Transact-SQL parsing. In passthrough mode, the client program issues Oracle SQL statements directly to the Oracle database, and the results are converted into a form that the Open Client interface understands.

• Oracle-to-Open Client Datatype Conversions for Numeric Data with create proxy_table
  Oracle datatypes are converted to the Open Client datatypes when in passthrough mode.
• Oracle-to-Adaptive Server Datatype Conversions for Non-Numeric Data with create proxy_table
  Oracle datatypes are converted to the Adaptive Server datatypes when in passthrough mode.