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