Inserting DB2 records on iSeries to SQL Server 2005 Table

5 pts.
Tags:
DB2
iSeries
SQL Server 2005
I need to insert records from a DB2 file residing on an iSeries to a SQL Server 2005 table on a remote system. How can I do this in a CL or RPG ? Thanks
ASKED: June 12, 2010  12:27 AM
UPDATED: June 20, 2011  2:37 PM

Answer Wiki

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

Practically speaking, you almost certainly won’t use CL nor RPG to do this. You’ll use Java and JDBC. You would use ILE RPG to invoke the Java methods, though, and possibly use CL to call the RPG.

Microsoft’s implementation of ODBC was originally kind of a proprietary superset of a subset of the open DRDA specs. And AFAIK, the only driver MS has made available for i5/OS is their Type 4 JDBC driver.

Tom

Discuss This Question: 4  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
  • philpl1jb
    But it is really easy to pull them from the SQLserver side. Phil
    48,575 pointsBadges:
    report
  • TomLiotta
    ...easy to pull them from the SQLserver side. It sure helps when the database vendor provides drivers for other platforms, eh? Tom
    125,585 pointsBadges:
    report
  • Masslk
    actually i want to transfer data from db2 as400 to sql2005 automatically, and sql2005 will integrate with visual studio c#
    10 pointsBadges:
    report
  • Lacain
    I have accomplished something similar in the past. I created a Linked Server for the AS400 on our 2005 SQL Server. Created a stored procedure that queries the DB2 table and inserts the data into the SQL 2005 table. The process had to be executed daily, so I setup a SQL Server Agent job with a daily schedule, so that the stored procedure would run daily. This would probably work if you just needed to obtain the data on a scheduled interval.
    20 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