February 27, 2006 at 9:42 am
What is the best way to move data to mainframe database (DB2) from SQL Server?
Can DTS be used along with an OLE Provider? Or would DB2 Connect be a better route?
TIA
February 28, 2006 at 9:04 am
I don't know which method is best, but we use DTS and connect to a DB2 ODBC driver to push data and it works fine. I guess you'd need to try different methods to see which works better for your environment.
February 28, 2006 at 11:08 am
Hi Linda,
How do you handle pushing data to packed fields on a DB2 table?
February 28, 2006 at 12:10 pm
Sorry but I don't know much about the DB2 databases. You may need to get with your DB2 expert or just do some testing. Our data pushes are very basic and simple.
February 28, 2006 at 5:27 pm
We are being recommended to use DB Connect to connect to the mainframe. Is this the same as ODBC?
March 1, 2006 at 5:39 am
I'm not sure. You may need to install it and check the ODBC Administrator for a driver. Even if it uses OLE DB you may be able to use it in a link, but you'd just have to try it.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply