Re: Weird issue with displaying journal data for a file

are the relative record numbers the same?
(meaning there may be multiple records with same key, or the key field
changed...)
On 8/22/2012 11:09 AM, Jeff Young 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,

--
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.