If your CSAs will access remote databases through DirectConnect, you need to be aware of how the DirectConnect configuration properties affect request and result processing.
Adaptive Server Enterprise uses Transact-SQL, while DB2 uses IBM’s version of SQL. Consequently, SQL statements written for Adaptive Server Enterprise generally do not perform as expected when executed against DB2. To handle this discrepancy, DirectConnect can be configured one of the following ways:
PASSTHROUGH mode, to pass through the IBM SQL
SYBASE mode, to transform the IBM SQL to Transact-SQL
For more information on DirectConnect property settings, see the appropriate Mainframe Connect DirectConnect for z/OS Option User's Guide for DB2 Access Services.
