cindyfiller
asked on
AS400 quick report to display detail records with totals
It's been a long time since I've worked on an AS400. I can still change a little RPG code and do a few things, but my skills are not there any more. I have a temp file that I want to print a quick report on inlcuding the detail lines and then grand totals of a few columns. I want to do it using a quick tool. I've used DFU in the past to generate a report with totals - but that was during data entry/update. Can DFU or another tool take this temp file and create a quick report with grand totals? I'm not sure what tool to use or if there is one that can be used in this case. I'd much rather work with a tool than try and do RPG.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Use SQL instead of QmQRY if it is a one shot only program
Afaik query is part of the OS and qmqry is not but I am away from a server and may be wrong.
Query/400 is an additional-charge licensed program, but you'll find it on most AS/400s.
Basic qmqry commands are part of the base OS (CRTQMQRY, STRQMQRY). Query Manager provides additional functionality on top of the basic qmqry commands, and is an additional-charge licensed program.
- Gary Patterson
Basic qmqry commands are part of the base OS (CRTQMQRY, STRQMQRY). Query Manager provides additional functionality on top of the basic qmqry commands, and is an additional-charge licensed program.
- Gary Patterson
ASKER