ECDA Option
for Oracle has different reference topics that you can check for additional information.
Connect Handler for ECDA Option for Oracle
The connect handler for ECDA Option for Oracle creates Open Server threads and connects to Oracle on behalf of the Adaptive Server user.
SQL Command Handling
ECDA Option for Oracle operates in passthrough mode unless it is used with Adaptive Server. In passthrough mode, the ECDA Option for Oracle passes SQL directly to the Oracle database with no transformation.
Support for Text and Image Datatypes
ECDA Option for Oracle supports columns of datatype text and image when used with Adaptive Server. ECDA Option for Oracle provides text pointers, which are handles that reference text or image values in readtext, writetext, and select commands.
Localization and Internationalization
When Adaptive Server communicates with ECDA Option for Oracle, client language and the default character set are passed as thread properties. ECDA Option for Oracle interacts with Oracle, conveying the client language and Open Server character set. As a result, Adaptive Server receives the character data and error messages in the correct language and character set.
Blank-Padded Comparisons
Oracle does not make blank-padded comparison for arguments to like clauses. However, when executed against a table on Adaptive Server, the same SQL statement fetches the row.
passthrough Mode
passthrough mode allows an ECDA Option for Oracle client to interact directly with an Oracle database using native Oracle SQL.
Datatype Conversion
ECDA Option for Oracle constructs syntax for Oracle datatypes.
Global Variables
Use the select @@variable_name command to list global variables.
Set Commands
Set commands affect only the connection on which they are issued. Other connections and the configuration file remain unchanged.