MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » May 2014

Re: Search a MSGFILE by text



fixed

Dan:

If you had Mike Faust's GETMESSAGES subprocedure/service program and the GETMESSAGES user-defined table function defined on your system, you could do the search dynamically like this:

SELECT *
FROM TABLE(mylib/getMessages('QSYS ', 'QCPFMSG ')) Msgs
where upper(MSGTEXT) like '%LOGICAL%'

See: http://www.mcpressonline.com/programming/rpg/cool-things-sql-functions-and-list-apis.html

- sjl


"Dan Rasch" wrote in message news:mailman.276.1400508651.31233.midrange-l@xxxxxxxxxxxx...

Does anyone know of a method to search message files by a text string?

Thanks,

Dan Rasch
=





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact