By translating dialect and syntax of the SQL statements the DB2 access service receives, passthrough and sybase transformation modes allow you to write applications that meet your needs. Table 6-1 shows you what to consider when choosing the transformation mode.
Use passthrough mode for... |
Use sybase mode for... |
|---|---|
Optimum performance |
Portability across different database systems |
Use of DB2-specific dialect features |
Potential reuse of some existing applications written for Adaptive Server |
As shown in Figure 6-1, passthrough mode transfers similar dialect and syntax directly from the client application to the target database, saving time and resources. The sybase mode performs translation functions, changing the select statement from lowercase in the client application to uppercase in the target database.
Figure 6-1: passthrough and sybase transformation modes
The following sections describe each transformation mode.
