Specifies the mode a DB2 access service uses for SQL transformation.
SQLTransformation=[passthrough | sybase]
passthrough
passthrough indicates that a DB2 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 indicates that a DB2 access service performs SQL transformation on selected statements. It also allows the use of multi-part table names with the view command in SQL statements.
See “SQL transformation modes” for detailed information about passthrough and sybase modes.
For backward compatibility only, the DB2 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 are no longer supported and are identified here only for backward compatibility, refer to the MDI Database Gateway User’s Guide for your DB2 database and platform.
