Interesting.  I'm as surprised as you are that there is no record format
ID in the journal receiver.  Doesn't look like any easy way to
automagically handle different formats.

But then, your extraction app would have to be recompiled after every
format change anyway, so I think you've got the right idea with using a
cutoff timestamp.

BTW, did you notice that one of the *TYPE5 fields is "Arm Number"?  It's a
5-byte zone-decimal field.  What in the world is this about?  InfoCenter
describes this as "The number of the disk arm that contains the journal
entry."  I am baffled as to the usefulness of this information.

GA

--- Mike savino <mikejsavino@xxxxxxxxxxx> wrote:
> Background: I'm writing a fairly simple tool to extract Journal Entries
> for Specific Files on a Daily basis. Our procedure is to leave the 
> Receivers on the system for several days, so a nightly process should 
> get all changes to whatever files we specify. In this case we're 
> creating an Audit Trail for some of our JD Edwards Master Files. We use 
> Lakeview's Mimix product, so the Journal is already there. I'm using 
> DSPJRN to extract into a Type 1 outfile.  In testing, so far this seems 
> to work fine.
> I plan on taking the Data Portion of the Journal Entry and shoving it
> back into a Data Structure based on the Physical File so that we can do
> reporting on the activity that we capture. This part hasn't been started

> yet but obviously the Layout of the Data needs to come from somewhere in

> order to make sense out of it.
> 
> My Question is this: Since we use the JD Edwards Data base, there is a
> good chance that file layouts will change, if and when we do an upgrade.

> So a Journal Entry for the post-upgrade Item Master file might not "Fit"

> into the Data Structure for the pre-upgrade Item Master file. I was 
> hoping that maybe the Format ID of the File would be saved in the 
> Journal Entry, telling me what File Layout to use. But I've looked at 
> both the Type 1 and Type 5 Output Formats and I don't see a field that 
> looks a likely candidate to be Format ID. I suppose that a cuttoff Date 
> would serve the purpose, but it doesn't seem to be a very gracious 
> solution. Especially since it would have to be File Specific.
> 
> Well, that wasn't really a question, was it? But I think it gives the 
> picture. Is there something in the Journal Entry that would tip me off?
> Or does anybody out there have other ideas on how to handle this 
> situation?
> 
> Thanks,
> 
> Mike


__________________________________
Do you Yahoo!?
Yahoo! Search - Find what you?re looking for faster
http://search.yahoo.com

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.