Using 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 DB2 access service does not perform any SQL transformation. The 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. The 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 value is other than 500 and 37.