Actually, like most things on the AS400, there are different approaches to the same problem, rendering similar results. My technique in 2002 at National Rifle Assoc was to modify the DDS printfile, inserting comma after numeric fields, and Double-Quote Comma ", between alpha fields. Follow this by a CPYSPLF and then ESNDMAIL command with the attached file as type(.CSV) within the email package ESEND from A.S.C. (now HelpSystems.com) to send the . I had a small tool to do the insertions into the DDS, and often needed a human touch to format them, but of the top 10 reports in use, we moved these into an "Excel" delivery model in about 10 mandays.
Of course, just having every report generate a work-file before the print-report is the easiest way to plan for future delivery methods, be it Excel or email or some other future method.
Of course, just having every report generate a work-file before the print-report is the easiest way to plan for future delivery methods, be it Excel or email or some other future method.
Comment