Access Service User's Guide DirectConnect

Home

Access Service User's Guide DirectConnect

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 performs SQL transformation on selected statements.

Comments

See "SQL Transformation modes" for detailed information about Passthrough and Sybase modes.
For backward compatibility only, the access service also accepts the following parameters:
```
   [ 
 db2 | tsql0
  | tsql1
  | tsql2
  ]
```
Setting to db2 or tsql0 is the same as setting to passthrough. For a description of tsql1 and tsql2, which is no longer supported and is only identified here for backward compatibility, refer to the MDI Database Gateway User's Guide for your target database and platform.


	Expand Search