Transfer data from DB2 file to SQL Server file

5 pts.
Tags:
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 myself (perhaps using ODBC) Thanks all for help. Abdou

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • NarasimhaReddy
    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
    225 pointsBadges:
    report
  • Benderd
    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/
    40 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following