Getting DB2 data into SQL 2008 database

8800 pts.
Tags:
AS/400
DB2
iSeries
SQL 2008
We have a web service for placing orders and sending them to our iSeries. Basically front ending the EDI package on the iSeries. If the data is sent over without errors on the SQL insert to the DB2 databases the job runs. If there are run time errors during order processing the errors are logged to a file. What would be the best way to get these errors from the iSeries back over to our SQL server database for review in the web-service? Any suggestions would be great. I've read some of the posts and was wondering if there are any advancements since most of articles I read were from 2010, 2011.

Software/Hardware used:
as/400, Power7, SQL 20008, VB, NET

Answer Wiki

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

Discuss This Question: 1  Reply

 
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
  • TomLiotta
    Since Microsoft doesn't fully implement DRDA and they make only a JDBC driver available for AS/400s, a JDBC-based solution is likely. (I think I recall at least one 3rd-party product that can be installed, perhaps on a PC, that makes native SQL programming possible.)   However, you might make good use of AppServer4RPG on SourceForge. I have only followed development comment threads. I don't have SQL Server available right now, so I can't test to see if it's good enough.   Once installed and configured, testing to see if it works for your needs should be very easy. Otherwise, go get MS's JDBC driver and start coding the Java.   Tom
    125,585 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