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

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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