Getting DB2 data into SQL 2008 database
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
Software/Hardware used:
as/400, Power7, SQL 20008, VB, NET
ASKED:
March 19, 2013 7:59 PM
UPDATED:
March 20, 2013 11:52 AM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
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