Chapter 2: Configuring the Access Service Library for DirectConnect

SQLTransformation

Specifies the mode the access service uses for SQL transformation.

SQLTransformation=[passthrough | sybase | tsql0 | tsql1 | tsql2]

passthrough

passthrough specifies an access service to send all SQL statements to the database system as received, without transformation. A client application uses passthrough mode to gain direct access to DBMS capabilities.
sybase specifies an access service to perform SQL transformation of selected statements. It also allows the use of multi-part table names with the view command in SQL statements.
For backward compatibility only, the access service also accepts the following parameters:
```
   [tsql0 | tsql1 | tsql2]
```
- Setting to tsql0 mode is the same as setting to passthrough mode.
- Setting to tsql1 mode, the database gateway expects SQL written for DB2 but performs minor Adaptive Server adaptations.
- Setting to tsql2 modes, implies Transact-SQL, providing less than the desired results in every situation. It performs maximal request transformation, including parsing at the database gateway. For information about transformation modes, see Chapter 6, “Issuing SQL Statements.”

For additional information, refer to the MDI Database Gateway User’s Guide for your target database and platform.