Re: Journaled File Record Display Options?

[Bradley Stone <bvstone@xxxxxxxxx>]

I'd be more than willing to put the side by side view up if I can grab the
changes by RRN or something else.  I will dig into your information.

Thanks.  I see more answers coming in!

On Wed, May 30, 2018 at 8:15 AM Rob Berendt <rob@xxxxxxxxx> wrote:

> 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