• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 599
  • Last Modified:

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.  
0
cindyfiller
Asked:
cindyfiller
1 Solution
 
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.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now