Folks,

This may be a little off-topic, but perhaps someone can help.

I am doing a quick-and-dirty one-time transfer of a database from SQL Server to DB/2 on an AS/400. Took my dictionary tool and modified it pretty easily to build the database, put in keys and restraints, and all of that. My only problem is in transferring data itself. Since I did not want to get too deeply into this, I figured to open a view from the source, open a cursor from the destination, make the cursor updatable, append in the from one cursor to the next, and then do a simple TableUpdate(.t.). (this is in fox of course).

This works of course, but the performance is absolutely horrible. It takes typically 100 seconds to load 4000 records! Is this what I should expect? I'd like to run the transfer, but it will apparently take a couple of days. Before I just sit there and stare at it for that long, I thought that just maybe there are some ODBC settings that might speed this up. A day of testing might not hurt if I can learn something here.

FWIW, can't use DTS to export, though it would have been a nice trick. SQL server dies a horrible death if you ask it to go from OLE DB SQL to OLE DB DB/2. It fails on practically anything that is not a char field, and mangles the names of the tables. Wondering if that is intentional :(

As always,
TIA...