Re: Journaled File Record Display Options?

I think I know what you want. There is an sql service to look at the
journal and it's pretty good. However, where it falls short is breaking
down the old and the new image into their respective columns. It's almost
as if you have to code an RPG program to bounce that old and new images
against an externally defined data structure based on the underlying
table.

https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20i%20Technology%20Updates/page/DISPLAY_JOURNAL%20(easier%20searches%20of%20Audit%20Journal)

I tried to figure out a UDTF (perhaps written in RPG) to do this but I
have other priorities. Besides it would have to be table specific.

If you want to whip up an RFE on this I would be interested. I thought I
did but I just checked and I don't see it. Perhaps I was limiting my
imagination as to how I would use RPG to do this.

IDK if DBU does this.

An alternative is to consider temporal tables.

You could imbed the SQL service into an RPG program and use your DS's that
way.


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: 05/30/2018 08:41 AM
Subject: Journaled File Record Display Options?
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



I have a client looking for some software, or an easy way to create an
application, that you can view changes to journaled files. Something like
a side by side view of original, changed, etc, in order of time/date
changed.

Is there anything like that out there, or some new SQL functions that
would
make this an easy to build app? Most likely would be a web app as there
isn't much 5250 real estate for something like this.

This is going to be for specific records in a file (keyed), so there will
be drilling down to find specific sets of data, and then wanting to view
the changes for the record(s) in question.

Think of book editing and wanting to see certain sentence(s) and or
paragraph(s). It's not that, but similar.

Bradley V. Stone
www.bvstools.com
MAILTOOL Benefit #4 <https://www.bvstools.com/mailtool.html>: Easily add
attachments of any type from the IFS to outgoing emails.
--
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: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
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: http://amzn.to/2dEadiD


--
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: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
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: http://amzn.to/2dEadiD