Home

	Expand Search

Access Service User's Guide DirectConnect for AS/400

Chapter 6 Issuing SQL statements

SQL Transformation modes

Passthrough mode

Passthrough mode

Use Passthrough mode when you want the client to have direct access to the capabilities of a DBMS target. In fact, the client must issue statements in the target SQL dialect, because the access service does not perform any transformation. Passthrough transformation mode does convert carriage returns and control characters (such as line feeds) to blanks, unless they are part of a quoted string. Otherwise, SQL statements pass untouched to the DBMS, and the results of each are returned to the client application.

Passthrough mode does not add semicolons between statements, nor does it check statement syntax. These tasks are performed entirely by the target database. However, Passthrough mode does convert all SQL keywords to uppercase when the DefaultTargetCodeset property has a value that is not 500 or 37.

For backward compatibility with the MDI Database Gateway, the access service changes any transformation mode request for TSQL0 to Passthrough mode, the default.