SQL transformation modes affect the way the DirectConnect access service modifies SQL statements that are written for one database but are processed against another.
The transformation mode primarily affects the way in which the access service treats incoming SQL statements, but it also affects these functional areas:
Transaction
Datatype handling
set statements
RSPs
ASE/CIS interoperability
ODBC driver interoperability
When you configure the access service with a specific transformation mode, that mode is effective for all client connections unless you use a set statement to alter it for a specific connection.
To make dialects appear as common SQL, the access service supports the following standard transformation modes:
passthrough
sybase