I understand from this that you want to copy data from a MS SQLServer table to a DB2 z/OS table.
Originally Posted by p19689
It all depends on the use case, when deciding for the "best way" to do this.
The easiest way for a large-volume data copy *could* be:
* save the table data into a CSV file,
* FTP that file to z/OS,
* load or insert the file data into the DB2 table.
All other scenarios will require you to write an MS-Windows application that connects to both databases (which requires the presence of DB2 connect, and of a DB2 client, on an MS-Windows server).
Last edited by Peter.Vanroose; 04-21-11 at 13:00.
__IBM Certified Database Administrator, DB2 9 for z/OS
__IBM Certified Application Developer
__ABIS Training and Consulting