Preparing to Use Express Transfer

Prepare to use the bulk-copy transfer, which can be interpreted as express transfer statements.

1. Set the TransferExpress property to yes, which causes the bulk-copy transfer statements to be interpreted as express transfer statements.
2. Enter the ODBC datasource name as the secondary name in the transfer statement.
   Express transfer is certified for target combinations, such as:

   • DB2 UDB z/OS, to and from Microsoft SQL Server, requires:

     • ECDA Option for ODBC

     • IBM DB2 CLI ODBC driver

   • DB2 UDB z/OS, to and from Adaptive Server, requires:

     • ECDA Option for ODBC

     • IBM DB2 CLI ODBC driver

     • Adaptive Server ODBC driver by Sybase

   • Microsoft SQL Server, to and from Adaptive Server, requires:

     • ECDA Option for ODBC

     • Microsoft SQL Server ODBC driver

     • Adaptive Server ODBC driver by Sybase

   The Adaptive Server ODBC Driver by Sybase is available on Windows and Linux platforms. For ECDA Option for ODBC on UNIX platforms, you can purchase a UNIX Adaptive Server driver from DataDirect Technologies. Obtain more information about the DataDirect drivers at the DataDirect Web site http://www.datadirect.com/index.html.

   Note: When you use an Adaptive Server driver, make the Adaptive Server connection the secondary connection. Use the Adaptive Server datasource name (DSN) for the secondary name.

• Using Express Transfer from DB2 to Microsoft SQL Server
  Use express transfer to transfer data from DB2 to Microsoft SQL Server.