Re: SQLRPGLE - Can SQL retrieve a message from a MSGF?

Sure...

Assuming you're on 7.3 TR 15
Take a look at QSYS2.MESSAGE_FILE_DATA
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/QSYS2.MESSAGE_FILE_DATA%20-%20View


select *
FROM QSYS2.MESSAGE_FILE_DATA
where MESSAGE_FILE_LIBRARY = 'QSYS' and MESSAGE_FILE = 'QSQLMSG'
limit 10;

If stuck back on 7.2...you could build your own UDF (or UDTF) that
wraps Retrieve Message (QMHRTVM) API

Charles

On Thu, Jan 30, 2020 at 3:13 PM Booth Martin <booth@xxxxxxxxxxxx> wrote:

Can SQL retrieve a message from a MSGF?

If so, how?

--
Booth Martin
www.martinvt.com
(870)576-9371
(802)461-5349

Patience, n. A minor form of despair, disguised as a virtue. -- Ambrose
Bierce
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com