Re: Weird issue with displaying journal data for a file

I'd have to agree with Gqcy & Gary...I'm guessing you're not actually
looking at the same record..

Include the RRN, library and file...might also include commit ID.

Finally, what's your WHERE statement look like?

Wondering if you're missing before/after rollback....

Charles

On Wed, Aug 22, 2012 at 12:09 PM, Jeff Young <jyoung0950@xxxxxxxxx> wrote:

I have a file that is jourlaned with both before and after images.
When I retreive the journal data for the file to a database file and query
it using SQL, I see the following results:
JOSEQN JOENTT JOTSTP JOPGM
IFITEM IFQWIP IFQCMM
1,073,529 UB 2012-08-22-09.51.24.902976 INUPIB
*EZRELEASE .00 .00
1,073,530 UP 2012-08-22-09.51.24.902976 INUPIB
*EZRELEASE .00 .00
1,082,218 UB 2012-08-22-10.00.20.052000 MOUPSH
*EZRELEASE 251.46 230.20
1,082,219 UP 2012-08-22-10.00.20.052000 MOUPSH
*EZRELEASE 251.46 230.20

I have manualy verified this information by displaying the journal data for
the file and viewing each record.
My question is: Since the entry at sequence 1,073,530 (after update) shows
a value for IFQCMM of 0.00, why does the next entry for that item (before
image) at sequence 1,082,218 show a value of 230.20?
There were no records in the journal for this item between 1,073,530 and
1,082,218.

Thanks,
--
Jeff Young
Sr. Programmer Analyst
--
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: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.