Preparing to use express transfer

To prepare to use express transfer

Set the TransferExpress property to yes, which causes the bulk copy transfer statements to be interpreted as express transfer statements.
Enter the ODBC data source name as the secondary name in the transfer statement.

Express transfer is certified for the following target combinations:

DB2 UDB z/OS, to and from Microsoft SQL Server, requires the following:
- ECDA Option for ODBC
- IBM DB2 CLI ODBC driver
DB2 UDB z/OS, to and from ASE, requires the following:
- ECDA Option for ODBC
- IBM DB2 CLI ODBC driver
- ASE ODBC Driver by Sybase
Microsoft SQL Server, to and from ASE, requires the following:
- ECDA Option for ODBC
- Microsoft SQL Server ODBC driver
- ASE ODBC Driver by Sybase

The ASE ODBC Driver by Sybase is available on Windows and Linux platforms. For ECDA Option for ODBC on UNIX platforms, you can purchase a UNIX ASE driver from DataDirect Technologies. More information about DataDirect drivers can be found at the DataDirect Web site.

When you use an ASE driver, make the ASE connection the secondary connection. Use the ASE data source name (DSN) for the secondary name.

Example of an express transfer

This example shows how you can express transfer data from DB2 to Microsoft SQL Server. It uses an isql connection to DB2 through ECDA Option for ODBC (primary server), and an ODBC DSN (on the primary server machine) for a Microsoft SQL Server target called “MSQL-DSN.”

To use express transfer from DB2 to Microsoft SQL Server

Connect to DB2 through the primary server:
```
-isql -Sdcdb2udb - Uuserid -Ppassword
```
Set TransferExpress to yes.

Enter:

Transfer to ‘MSQL-DSN userid password’;
with insert into MSQL-table;
Select * from db2-table