Home > IT Answers > AS/400 > Data transfer from DB2 (AS400) TO SQL SERVER 2005
HABDOU
5 pts.
 Data transfer from DB2 (AS400) TO SQL SERVER 2005
AS/400, AS/400 DB2, Data transfer, DB2, ODBC, SQL Server 2005
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

Software/Hardware used:
ASKED: April 1, 2008  3:03 PM
UPDATED: November 28, 2011  9:03 AM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  April 2, 2008  2:01 pm  by  DanTheMan 2   395 pts.
All Answer Wiki Contributors:  DanTheMan 2   395 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

NarasimhaReddy
 225 pts.
 

Using OpenSource solution ArdGate, you could access any JDBC capable database with all AS/400 SQL interfaces (embedded SQL in COBOL or RPG, QM Query, interactive SQL, RUNSQLSTM). ArdGate is based on AppServer4RPG and very fast and scalable, you could access all databases on record level in real time, direct from your RPG or COBOL applications.

Dieter Bender

Access any Database from ADABAS to XBASE with embedded SQL in RPG. http://sourceforge.net/projects/appserver4rpg/

Benderd
 40 pts.