Q
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.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close