Querying a Message File

[John]

Hi
Is it possible to query a message file?
We use just one message file for our entire application, and it has
hundreds of messages. To a certain extent it is organised, using
prefixes for the different areas of the system. But over the years it
has gotten a little messy.
What I was hoping to be able to do was an SQL with a fuzzy search on
the text to find a particular message ID.

Any ideas?

TIA
John

[jb]

"John" <john_pre...@hotmail.com> wrote in message
news:f84b1305.04021...@posting.google.com...

My use shows DSPMSGD *all lib/msgf detail(*basic) output(*print) is the
simplest. It is then easy to use in SEU via F15. You might do
OVRPRTF FILE(QPMSGD) PAGESIZE(255) OVRFLW(255) beforehand to cut down on the
number of page separators.
Once there you can use cpysplf to get the data into a db file of some sort.
But its not quite realtime is it ?

--
Jonathan.

[John]

<jb> wrote in message news:<402a0aff$0$28841$afc3...@news.easynet.co.uk>...

Thanks Jonathon
Thats exactly the sort of thing I'm looking for.
Yeah, not exactly realtime, but done once a week should keep me
relatively up to date.

Cheers!

[QMAGIC]

John,

I have written a work message file utility that has sort, search and
subset along with the normal add/chg/del abilities. I'm thinking of
putting it out as shareware. If you're interested I'll give you a copy
to play with. It's written for V5r1 or later. Below is what the main
screen looks like.

One feature I like is that I can subset the list based on some text
and then do a search within the subsetted list on different text. The
sort ability allows you to sort on Message ID and Severity Code and
position to base on either of them. When sorting by text it uses the
cursor position to determine where within the text to sort. For
example you have a standard prefix on your message text of repeating
the message ID in the first 7 positions with a ‘-‘ after it. (Our
company standard) then sorting by text would be no different then
sorting by message id so by putting the cursor in position 9 and
pressing F2 then will sort based on the 9th position of the text.

send me an email to dannelso...@cox.net (remove nojunk) if your
interested.

Dan

User: DANELSON Work with Message File 2/12/04
08:37:0

Library: *LIBL Sub Set (F14):
Case: N (Y/N
File: TAXMSGF Range (F15): From: *FIRST to *LAST

Pos to Msg ID: Find (F16):
Case: N (Y/N

Options: 2=Change 3=Copy 4=Delete 5=Details 6=Print
O Msg ID SV Description
CCA0000 00 CCA000- County level exempt - have county certificate.
CCB0000 00 CCB000- County level not exempt, no county certificate
found.
CCC0000 00 CCC000- County level exempt - use state default.
CCD0000 00 CCC000- County not level exempt - use state default.
CCE0000 00 CSE000- Certificate covers product
CCF0000 00 CSF000- Certificate does not cover product
CCG0000 00 CSG000- Special rate record found.
CCH0000 00 CSH000- File indicates to use Special Rate File, special
rates no
CCI0000 00 CSI000- Job number passed, record not found, transaction
not exem
CCJ0000 00 CSJ000- Job number passed, record found, job is exempt at
county
CCK0000 00 CSK000- Job number passed, record found, job is taxable
at county
CCL0000 00 CSL000- Job number passed, record found, use special rate
at co

F1=Help F2=Sort F3=Exit F4=Prompt F5=Refresh F6=AddMsg
F24=More Cmds
First Message is being displayed at the top.

john_pre...@hotmail.com (John) wrote in message news:<f84b1305.04021...@posting.google.com>...

[Will]

I think Bradley Stone has what you're looking for:

http://www.bvstools.com/scnmsgf.html

Will