Re: Changing variables &1, &2 in a message text

----------------------------------------------------------------------
I can vouch that OVRPRTF FILE(QPQUPRFIL) PRTTXT('Select parms here') does
work.  In fact, we have our initial signon program automatically do this.
It retrieves the text from the user profile and drops it in the PRTTXT
parameter.  That way, every time a user runs a query, it always prints at
the bottom of the page, the person who ran it.
Carmen


date: Thu, 1 Jul 2004 15:00:49 +0100
from: Mike Barton <Mike.Barton@xxxxxxxxxxxxxxxxx>
subject: Re: Changing variables &1, &2 in a message text

>Hello, everybody!
>
>I would like to know how to change variables &1, &2, etc. in the 
>message
QRX1905 (End of Report) before actually running a query. The idea is to
>print some selection parameters using this message, since I don't know 
>of any way to print that in the heading page of the query. My idea is 
>to
create
<snip>
 
>Humberto Almodsvar

Humberto
        you can do this several ways, one that springs to mind is to use
something like OVRPRTF FILE(QPQUPRFIL) PRTTXT('Select parms here') before
you run the query.
Havn't tried this so cannot vouch if it works ok..

Alternatively, you can as suggested change the message text ID.
Best way to do this is not to change the actual system message but use an
override instead:
CRTMSGF    MSGF(QTEMP/QQRYMSG )
ADDMSGD    MSGID(QRX1905) MSGF(QTEMP/QQRYMSG) MSG('Select parms here')
OVRMSGF    MSGF(QQRYMSG ) TOMSGF(QTEMP/QQRYMSG )  
now run query
again, havn't tried this so cannot vouch if it works ok..

HTH

Mike