Re: Querying message descriptions

You can't do that directly... SCNMSGF is an interactive green screen
application. Your request that I replied to was in an answer to if there
were APIs like WRKMSGD. So yes, there are APIs, and SCNMSGF uses them,
but you're not going to call the APIs from SQL either.

Brad
www.bvstools.com

On Mon, Dec 7, 2015 at 10:54 AM, <rob@xxxxxxxxx> wrote:

How do you call SCNMSGF from SQL linking one table with a list of message
id's to the list of messages within a message file?


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Bradley Stone <bvstone@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 12/07/2015 11:52 AM
Subject: Re: Querying message descriptions
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



SCNMSGF does. It lists messages and allow search by ID or message text.

Brad
www.bvstools.com

On Mon, Dec 7, 2015 at 10:48 AM, <rob@xxxxxxxxx> wrote:

Funny thing is there are these APIs:
Retrieve Message (QMHRTVM)
Retrieve Message File Attributes (QMHRMFAT)

But neither one lists out the messages within the message file like
WRKMSGD does. Is there such an API?


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: rob@xxxxxxxxx
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 12/07/2015 11:34 AM
Subject: Re: Querying message descriptions
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



I do not see an IBM supplied one listed at:

http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/rzajq/rzajqservicesmessage.htm?lang=en-us

Perhaps you could write your own UDTF that would perform such a

function.

Here's a sample of a homegrown function calling an API
http://archive.midrange.com/midrange-l/201511/msg00078.html


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: darren@xxxxxxxxx
To: "midrange-l " <midrange-l@xxxxxxxxxxxx>
Date: 12/07/2015 11:04 AM
Subject: Querying message descriptions
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>




Someone asked me for a list of possible messages a program might send. I
compiled a list of about 250 message ID's that refer to a vendors

message

file. Is there an easy way to query the message description in a

message

file? I'd like to join this list of ID's to the message file to convert
the ID's into descriptions. I've searched and haven't located anything
like a SQL view or service that might help.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.