× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.