How to get a JBA Supplier History by Country I was asked to build a spreadsheet showing “All purchase totals for all suppliers by year and include the supplier country code” A simple request – so I thought I would blog the process for those new programers out there or for anyone wanting to understand

Read More

Have you ever wanted to extract some data out of an IBMi/AS400 file using SQL and then email that data to someone as an Excel Spreadsheet? Now you can… all from one IBMi command without having to write any CL code to do it. Projex4i: DSTDTA command now handles SQL STRINGS for selecting data I

Read More