Midrange News for the IBM i Community


Posted by: abc4000
OPNQRYF - Message on Bottom
has no ratings.
Published: 19 Apr 2013
Revised: 19 Apr 2013 - 1560 days ago
Last viewed on: 27 Jul 2017 (2826 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

OPNQRYF - Message on Bottom Published by: abc4000 on 19 Apr 2013 view comments(3)

All:
How I remove bottome message when OPNQRYF is building ... for example: "Query running....".?

Do we any CL Command to stop this message ?

Thank you,

ABC400

Return to midrangenews.com home page.
Sort Ascend | Descend

COMMENTS

(Sign in to Post a Comment)
Posted by: DaleB
Premium member *
Reading, PA
Comment on: OPNQRYF - Message on Bottom
Posted: 4 years 3 months 9 days 11 hours 48 minutes ago

There are (at least) two ways:

You can stop all messages for a user with CHGUSRPRF and specify *NOSTSMSG on USROPT().

You can stop messages in a job with CHGJOB and specify *NONE on STSMSG(). You may want to RTVJOBA STSMSG() before you change it, so you can put it back to the original setting after the query is done.

Posted by: Ringer
Premium member *
Comment on: OPNQRYF - Message on Bottom
Posted: 4 years 3 months 9 days 11 hours 27 minutes ago

Yeah what Dale said.

DCL  VAR(&JobStsMsg ) TYPE(*CHAR) LEN(7) 
/* Grab some Job Info */                                      
RTVJOBA StsMsg(&JobStsMsg)
/* Hide query info from interactive user */ 
CHGJOB STSMSG(*NONE)                        
/* Restore prior status message setting */ 
CHGJOB STSMSG(&JobStsMsg)                  

Chris Ringer

Posted by: abc4000
Premium member *
Comment on: OPNQRYF - Message on Bottom
Posted: 4 years 3 months 9 days 11 hours 11 minutes ago

Thank you everyone. CHGJOB STSMSG(*NONE) worked in CLP.