"Dave" <ad***@comcast.net> wrote in message
news:hwTwb.306983$Tr4.967143@attbi_s03...
Thanks for quick response Mark.
I am trying to copy from MS SQL server database to DB2 database (and
not DB2 to DB2)
I though import & Load utilities of DB2 are meant for copying from one
DB2 db to another DB2 db.
Here is one of the errors that we are getting while running DTS tool of
MS SQL server...
SQL0206N "<Column Name>" is not valid in the context where it is used.
SQLSTATE=42703
I guess my question is are there any good IBM tools or third party
tools that help us migrate the
data from SQL server to DB2 database ?
Thanks
If you can export the data from MS SQL in fixed length (positional) or
delimited format ("|" works well as a delimiter, but any delimiter can be
defined) into regular sequential files, then you can use the import utility.
The data does not have to come from DB2. Make sure that dates are in the
format of YYYY-MM-DD, YYYY/MM/DD, MM-DD-YYYY, etc.
For medium to large tables, make sure you set the commit interval to about
500-1000 so you will not fill up the logs. Check the Command Reference for
details.
The load utility can also be used, but may be a problem with generated
always columns.
I have found that tools such as DTS are very good for lightening your
wallet, but not much else.