Re: Weird issue with displaying journal data for a file

[Gqcy <gmufasa01@xxxxxxxxx>]

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,