Re: Removing a message from the job log

Hi Dean
I also use this command in (multiple) RPG programs, and the response (or
lack thereof) is negligible.
However, saying that, these are NOT part of a web service


Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

midrange-l-bounces@xxxxxxxxxxxx wrote on 04/01/2009 11:19:31 AM:

Hi Alan,

Actually, I already downloaded that command. The reason I wasn't sure if

I wanted to use it in this situation was due to how efficient it is.

This

message is generated in an RPG that is part of a web service. I was
concerned about the response time of the web service if I use the

RMVJLMSG

command since it appears to list all the messages in the job log and then

looks for the ones it wants to remove.

Dean Eshleman,
MMA, Inc.

On Wed, 1 Apr 2009 10:13:58 -0400, in midrange.midrange-l you wrote:

Hi Dean
there is a command called RMVJLMSG that I have downloaded and now use
extensively to remove whatever message is wanted to be removed (in my

case

CPF5020)
However, it only seems to be available from systemiNetwork
The author is named Rory Hewitt


Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill



Dean.Eshleman@mma
-online.org
Sent by: To
midrange-l-bounce midrange-l@xxxxxxxxxxxx
s@xxxxxxxxxxxx cc

Subject
04/01/2009 10:02 Removing a message from the job

log

AM


Please respond to
Midrange Systems
Technical
Discussion
<midrange-l@midra
nge.com>






I have an SQLRPGLE program that executes a close cursor instruction at

the

beginning of the program. Sometimes, this generates a message in the

job

log "Cursor SQL_EXTRACT not open." I would like to remove the message
from the job log when this happens. However, I'm not sure if I can.

When

I look at the details of the message, the from program and to program

are

both QSQRUN4 which is probably below my program in the call stack. I
tried using the QMHRCVPM API to retrieve the message, but no luck. Can

I

remove this message?

I guess my other option is to prevent the message in the first place. I
guess I'll look into that as well.

Dean Eshleman,
MMA, Inc.

______________________________________________________________________
Confidentiality Notice: This information is intended only for the
individual or entity named. If you are not the intended recipient, do

not

use or disclose this information. If you received this e-mail in error,
please delete or otherwise destroy it and contact us at (800) 348-7468

so

we can take steps to avoid such transmissions errors in the future.

Thank

you.

______________________________________________________________________
Confidentiality Notice: This information is intended only for the
individual or entity named. If you are not the intended recipient,
do not use or disclose this information. If you received this e-
mail in error, please delete or otherwise destroy it and contact us
at (800) 348-7468 so we can take steps to avoid such transmissions
errors in the future. Thank you.
--
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.