× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Actually - it was part of the Dirty Harry Series - Magnum force

Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Danny Hayes
Sent: Wednesday, September 25, 2019 1:00 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] RE: [EXT] RE: extracting audit journal info

Rob,

Sorry to correct you but it was Dirty Harry and not from a Western.

Danny

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Rob Berendt
Sent: Wednesday, September 25, 2019 9:51 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: [EXT] RE: extracting audit journal info

External Email: This is an EXTERNAL email do not click links or open attachments unless you know the content is safe. Please use caution with Urgent Requests.


"A man's got to know his limitations." Thanks for the opportunity to quote Clint Eastwood westerns.


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
https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.dekko.com&amp;data=02%7C01%7Cdanny_hayes%40genpt.com%7C7012a56368c0456364ac08d741bf5e83%7Cb439d764f2cb43eaac052e373c83043e%7C0%7C0%7C637050162491285361&amp;sdata=FvPQMdm0XkOrxEZEl8SRyFJaQ3ISm0s%2BQqTyDJjodQU%3D&amp;reserved=0


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Gerald Magnuson
Sent: Wednesday, September 25, 2019 9:22 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: extracting audit journal info

CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.


I truly wish I could compose requests in an effective way... I have
placed RFE's before, only to find them miss-worded or too confusing to be understood.
We not only have the Display_Journal() table function needing the textual representation of the codes, but many other SQL services may benefit from some IBM internal magic.


On Wed, Sep 25, 2019 at 7:56 AM Rob Berendt <rob@xxxxxxxxx> wrote:

Your turn to submit that RFE. Or maybe even the OP's turn.
I have this other RFE I want to submit that I find urgent and highly
important (if only I can remember what it was, oops, now I remember).
:-)

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
https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.d
ekko.com&amp;data=02%7C01%7Cdanny_hayes%40genpt.com%7C7012a56368c04563
64ac08d741bf5e83%7Cb439d764f2cb43eaac052e373c83043e%7C0%7C0%7C63705016
2491285361&amp;sdata=FvPQMdm0XkOrxEZEl8SRyFJaQ3ISm0s%2BQqTyDJjodQU%3D&
amp;reserved=0


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
Vernon Hamberg
Sent: Wednesday, September 25, 2019 9:14 AM
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: extracting audit journal info

CAUTION: This email originated from outside of the organization. Do
not click links or open attachments unless you recognize the sender
and know the content is safe.


Hey Rob!

Good find - turns out there are a whole bunch of messages with these
texts
- CPX7064 - CPX7097. They all appear to have a count at the start of
how many texts are in the message.

Some of these look like later additions as more auditable events come
into play. So the OP could get the descriptions from here. It's
important to remember that the last 4 characters in a MSGID are
hexadecimal characters, so there is, if I remember what I saw 5 minutes ago, a CPX708A, for example.

My assumption is that IBM keeps these in an orderly space - there is
more room in that basic range. Since we don't really know, there might
be things we'd miss.

What would be cool is to have an RFE to add these descriptions to the
output of the table function, since any change to these captions
should be known better to IBM than to us mere civilians.

Nonetheless, thanks for a great reminder of how much we see on the
screens comes from message files - format lines in SEU (yes, it's kind
of historical now, indeed!!) And how one method for globalization works.

Regards
Vern

On 9/25/2019 7:04 AM, Rob Berendt wrote:
Vern,
(responding to the slap in the face with a glove) I accept your
challenge. Let's start with a hypothesis. The hypothesis being
that a
system which supports multiple languages probably does so through the
use of message files. So one would simply scan all message files for that text.
One way to do that is with
SELECT MESSAGE_FILE_LIBRARY, -- MSGF_LIB VARCHAR(10)
MESSAGE_FILE, -- MSGF VARCHAR(10)
MESSAGE_ID, -- MSGID CHARACTER(7)
MESSAGE_TEXT, -- MSG_TEXT VARGRAPHIC(132)
...
WHERE MESSAGE_TEXT LIKE('%Previous journal receivers%') or
MESSAGE_SECOND_LEVEL_TEXT LIKE('%Previous journal receivers%') or
MESSAGE_TEXT like('%Journal or receiver operation%') or
MESSAGE_SECOND_LEVEL_TEXT like('%Journal or receiver operation%')
;
Results were
QSYS QCPFMSG CPX7064
QSYS QCPFMSG CPX7068
We win.

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
https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww
.dekko.com&amp;data=02%7C01%7Cdanny_hayes%40genpt.com%7C7012a56368c0
456364ac08d741bf5e83%7Cb439d764f2cb43eaac052e373c83043e%7C0%7C0%7C63
7050162491285361&amp;sdata=FvPQMdm0XkOrxEZEl8SRyFJaQ3ISm0s%2BQqTyDJj
odQU%3D&amp;reserved=0 -----Original
Message----- From: MIDRANGE-L
<midrange-l-bounces@xxxxxxxxxxxxxxxxxx>
On Behalf Of Vernon Hamberg Sent: Tuesday, September 24, 2019 7:00
PM
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxxxxxxxx> Subject: Re: extracting audit
journal info CAUTION: This email originated from outside of the organization.
Do not click links or open attachments unless you recognize the
sender and know the content is safe. Those layouts are for outfiles
for the different types of journal entries. The display_journal()
table function is a different animal. I don't remember whether the
screen presentation of DSPJRN has a textual meaning for the various
codes - if so, there is probably a place to pull them from. Cheers
Vern

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit:
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flist
s.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&amp;data=02%7C01%7Cda
nny_hayes%40genpt.com%7C7012a56368c0456364ac08d741bf5e83%7Cb439d764f2c
b43eaac052e373c83043e%7C0%7C0%7C637050162491285361&amp;sdata=dBVbxcRk6
mLnPVgzZsROrWCFOskVQhtN39MULroLCRQ%3D&amp;reserved=0
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fmidrange-l&amp;data=02%7C01%7Cdanny_hayes%40genpt.com%7C7012a56368c0456364ac08d741bf5e83%7Cb439d764f2cb43eaac052e373c83043e%7C0%7C0%7C637050162491285361&amp;sdata=Uwow%2B%2BU8qI7EbWItVHS%2Fjh5iRmeqwxze2%2BVbHyhNIE4%3D&amp;reserved=0.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Famaz
on.midrange.com&amp;data=02%7C01%7Cdanny_hayes%40genpt.com%7C7012a5636
8c0456364ac08d741bf5e83%7Cb439d764f2cb43eaac052e373c83043e%7C0%7C0%7C6
37050162491285361&amp;sdata=Sn4mgozMNErrg4k89lilIcea%2BJtrrj%2FcS%2BoC
7sppC1E%3D&amp;reserved=0
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit:
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flist
s.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&amp;data=02%7C01%7Cda
nny_hayes%40genpt.com%7C7012a56368c0456364ac08d741bf5e83%7Cb439d764f2c
b43eaac052e373c83043e%7C0%7C0%7C637050162491285361&amp;sdata=dBVbxcRk6
mLnPVgzZsROrWCFOskVQhtN39MULroLCRQ%3D&amp;reserved=0
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fmidrange-l&amp;data=02%7C01%7Cdanny_hayes%40genpt.com%7C7012a56368c0456364ac08d741bf5e83%7Cb439d764f2cb43eaac052e373c83043e%7C0%7C0%7C637050162491285361&amp;sdata=Uwow%2B%2BU8qI7EbWItVHS%2Fjh5iRmeqwxze2%2BVbHyhNIE4%3D&amp;reserved=0.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Famaz
on.midrange.com&amp;data=02%7C01%7Cdanny_hayes%40genpt.com%7C7012a5636
8c0456364ac08d741bf5e83%7Cb439d764f2cb43eaac052e373c83043e%7C0%7C0%7C6
37050162491285361&amp;sdata=Sn4mgozMNErrg4k89lilIcea%2BJtrrj%2FcS%2BoC
7sppC1E%3D&amp;reserved=0

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&amp;data=02%7C01%7Cdanny_hayes%40genpt.com%7C7012a56368c0456364ac08d741bf5e83%7Cb439d764f2cb43eaac052e373c83043e%7C0%7C0%7C637050162491285361&amp;sdata=dBVbxcRk6mLnPVgzZsROrWCFOskVQhtN39MULroLCRQ%3D&amp;reserved=0
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fmidrange-l&amp;data=02%7C01%7Cdanny_hayes%40genpt.com%7C7012a56368c0456364ac08d741bf5e83%7Cb439d764f2cb43eaac052e373c83043e%7C0%7C0%7C637050162491285361&amp;sdata=Uwow%2B%2BU8qI7EbWItVHS%2Fjh5iRmeqwxze2%2BVbHyhNIE4%3D&amp;reserved=0.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Famazon.midrange.com&amp;data=02%7C01%7Cdanny_hayes%40genpt.com%7C7012a56368c0456364ac08d741bf5e83%7Cb439d764f2cb43eaac052e373c83043e%7C0%7C0%7C637050162491285361&amp;sdata=Sn4mgozMNErrg4k89lilIcea%2BJtrrj%2FcS%2BoC7sppC1E%3D&amp;reserved=0
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&amp;data=02%7C01%7Cdanny_hayes%40genpt.com%7C7012a56368c0456364ac08d741bf5e83%7Cb439d764f2cb43eaac052e373c83043e%7C0%7C0%7C637050162491285361&amp;sdata=dBVbxcRk6mLnPVgzZsROrWCFOskVQhtN39MULroLCRQ%3D&amp;reserved=0
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fmidrange-l&amp;data=02%7C01%7Cdanny_hayes%40genpt.com%7C7012a56368c0456364ac08d741bf5e83%7Cb439d764f2cb43eaac052e373c83043e%7C0%7C0%7C637050162491285361&amp;sdata=Uwow%2B%2BU8qI7EbWItVHS%2Fjh5iRmeqwxze2%2BVbHyhNIE4%3D&amp;reserved=0.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Famazon.midrange.com&amp;data=02%7C01%7Cdanny_hayes%40genpt.com%7C7012a56368c0456364ac08d741bf5e83%7Cb439d764f2cb43eaac052e373c83043e%7C0%7C0%7C637050162491285361&amp;sdata=Sn4mgozMNErrg4k89lilIcea%2BJtrrj%2FcS%2BoC7sppC1E%3D&amp;reserved=0
"This email and any attachments, contain Genuine Parts Company confidential information that is proprietary, privileged, and protected by applicable laws. If you have received this message in error and are not the intended recipient, you should not retain, distribute, disclose or use any of this information and you should destroy this email, any attachments or copies therein forthwith. Please notify the sender immediately by email if you have received this email in error."
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.