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.
All:How I remove bottome message when OPNQRYF is building ... for example: "Query running....".?
Do we any CL Command to stop this message ?
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.
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)
Thank you everyone. CHGJOB STSMSG(*NONE) worked in CLP.