Access Service User's Guide DirectConnect for AS/400

Home

Access Service User's Guide DirectConnect for AS/400

Chapter 2 Configuring the DirectConnect Access Service Library

Access service Target Interaction properties

SQLTransformation

Specifies the mode an access service uses for SQL transformation.

Syntax

SQLTransformation=[ passthrough | sybase ]

Default

passthrough

Values

passthrough specifies that an access service sends 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 that an access service transforms T- SQL to native SQL on selected statements.

Comments

See "SQL Transformation modes" for detailed information about Passthrough and Sybase modes.

- For information about transformation modes, see Chapter 6, "Issuing 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 SQL 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 additional information, refer to the MDI Database Gateway User's Guide for your target database and platform.


	Expand Search