Interfaces to/from iSeries DB2

Has anyone had success writing interfaces to process spares "issue" transactions FROM L2L, or Synch Item, Vendor, or Inventory TO L2L from the iSeries/DB2 database? Particularly XA/Mapics?  I'm not an XML programmer, and don't want to waste more time trying to learn if it's not going to work.  

There has to be a way to do this with ease. I just cannot accept that downloading  spreadsheets, which are missing the stockroom #, converting manually to Text, reformatting the dates, uploading to iSeries, and if any errors exist, re-doing the process - is the best way to go with this.     

Thank you!  


Please sign in to leave a comment.