Problem solve Get help with specific problems with your technologies, process and projects.

Export data from SQL Server 2000 to DB2/400

I want to export data from SQL Server 2000 to DB2/400 via Client Access ODBC driver (32 bit). I did it with the basic steps in SQL Server, but it doesn't work and I received an error message regarding the SQL provider.

If you exported the scripts to create the databases on DB2/400 from your SQL Server 2000 and ran them to create the databases on DB2 Universal for iSeries, there may be some naming convention problems if the field names or data types are not fully supported on the iSeries. I would suggest you check the tables created by your scripts on the iSeries system and verify the table names, field names and data types. This is most likely where you will find the answer.


Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: tips, tutorials and more.

Check out this online event, Getting the Most out of SQL & DB2 UDB for the iSeries.

Dig Deeper on Oracle on iSeries

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.