Using Express Transfer from DB2 to Microsoft SQL Server

Use express transfer to transfer data from DB2 to Microsoft SQL Server.

Use 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.”

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