This is where EXPJRNE really shines. :D
On Tuesday, January 29, 2019, 2:04:56 PM EST, Rob Berendt <rob@xxxxxxxxx> wrote:
The biggest drawback to this is parsing out the before/after images. They are in there but as two big strings. If you're really good you can build your own UDTF to take one of those images and parse it out. One method would be to take the big image and bounce it against an externally defined data structure in RPG and return all the individual columns as a "row" from a UDTF.
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jack Woehr
Sent: Tuesday, January 29, 2019 2:01 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Needle in Haystack - Seeking Offending Journal Entry
On Tue, Jan 29, 2019 at 11:59 AM Jack Woehr <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
-- v7.1
select * from table (
QSYS2.Display_Journal
Now to read Joe Pluta's article and figure out how to plow through what I've got looking for what I want!
--
Jack Woehr
Absolute Performance, Inc.
12303 Airport Way, Suite 100
Broomfield, CO 80021
NON-DISCLOSURE NOTICE: This communication including any and all attachments is for the intended recipient(s) only and may contain confidential and privileged information. If you are not the intended recipient of this communication, any disclosure, copying further distribution or use of this communication is prohibited. If you received this communication in error, please contact the sender and delete/destroy all copies of this communication immediately.
--
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.