Change Query/400's End-of-Report Line

Article ID: 10771

If you're bothered by the "*** END OF REPORT ***" message that appears at the bottom of your Query/400 printouts, try this solution.

Query/400 uses message QRX1905 in message file QQRYMSG as the source for the end-of-report message. With a little message-file manipulation, you can either remove the message from the query report or substitute your own message. Here's what you need to do:

Use the CRTMSGF (Create Message File) command to create a message file. Then use the ADDMSGD (Add Message Description) command to add message ID QRX1905 to the newly created message file, filling the first-level message text parameter (MSG) with your choice of messages for the bottom of the query report. To have no message appear, specify ' '.

Before running the query, use the OVRMSGF (Override with Message File) command to override message file QQRYMSG with your user-created message file. After running the query, use the DLTOVR (Delete Override) command to delete the message file override.

Tip by Gary Guthrie, Technical Editor, NEWS/400
This tip came from "44 AS/400 Programming Tips & Techniques" http://www.news400.com/artarchive/index.cfm?fuseaction=viewarticle&ArticleID=10558

ProVIP Sponsors

ProVIP Sponsors