Re: Is there a way to build a message in a program, retrieving a message from the message file and merging MSGDTA into it?

If you're trying to send these message to some destination, why not just use the SNDPGMMSG command? It has places for you to insert the &1 &2 without muss or fuss. SQL is nifty, but why reinvent the wheel??

==Paul E Musselman

.


At 1:02 PM -0400 4/21/21, a4g atl wrote:

I have a requirement to modify a program that uses messages from a message
file to display errors. The program is old and was cloned from an
interactive program that displayed messages. It is now a batch program that
sends the messages to nowhere.

I need to retrieve the message description and merge in the replace values
for &1, &2... where the MSGDTA exists.

I would like to use the SQL function

Select Message_TEXT from QSYS2.MESSAGE_FILE_DATA but need to find a way to
replace the &1, &2... with the real values.

Any Ideas?

TIA, Darryl Freinkel.