Showing posts with label howcan. Show all posts
Showing posts with label howcan. Show all posts

Wednesday, March 21, 2012

DTS data from MS SQL 2000 to DB2 7.1 on OS/390

I am trying to move data from SQL server table to a table in DB2 on
Z/os. I keep getting a message that the function is not supported. How
can I move data from sql server 2000 to db2 on os/390
could anybody please help ?

ThanksWell, if you're not set on DTS, then you could just unload the data
into a file, then use db2's load or import on that file.

Depending on your connectivity, you might need to move it up to the
mainframe to perform the load/import, and that'll require a conversion
to EBCDIC.

Having done it both ways, I *much* prefer using a set of utilities and
simple languages (ruby, python, etc) than DTS...