Home > IT Answers > DataManagement > Data transfer from DB2 (AS400) TO SQL SERVER ...
Help

Question

  Asked: Apr 1 2008   3:03 PM GMT
  Asked by: HABDOU

Data transfer from DB2 (AS400) TO SQL SERVER 2005


Data transfer, AS/400, DB2, SQL Server 2005, ODBC, AS/400 DB2

I want to transfer a data from a DB2 file to a SQL Server file.
I do not want to buy a software that do it.
I want to do it by my self (perhaps using ODBC)

Thinks all for help.

Abdou

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Apr 2 2008  2:01 PM GMT  by DanTheMan 2




You will have to create a link between your AS/400 and SQL server first using ODBC.

Then, create an SQL server database having a file definition corresponding to your AS/400 data description and then write a stored proc to insert informations into those files based on the external AS/400 file.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on DataManagement, AS/400 and Database.

Looking for relevant DataManagement Whitepapers? Visit the SearchDataManagement.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

NarasimhaReddy  |   Apr 3 2008  3:01PM GMT

We have data transfer from Db2 to SQL Server. We use JAVA program to transfer data with some changes to original data from DB2 before inserting/updating into SQL server. JAVA program can connect to DB2 & SQL server using IP address of both systems. (JAVA program runs on other PC).

But still, If anybody knows how to transfer using CL Commands or other programs(cobol/rpg) on as/400 pls explain.

Thanks & Regards
–Reddy