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.  
cindyfillerAsked:
Who is Participating?
 
shalomcCTOCommented:
use Query/400 or QmMqry.
commands are: wrkqry, strqm
0
 
cindyfillerAuthor Commented:
Thanks - won't be able to try it until this weekend, but will definitely try this.  Do these tools automatically come with the AS400 now?  
0
 
MurpheyApplication ConsultantCommented:
Use SQL instead of QmQRY if it is a one shot only program
0
 
shalomcCTOCommented:
Afaik query is part of the OS and qmqry is not but I am away from a server and may be wrong.
0
 
Gary PattersonVP Technology / Senior Consultant Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.