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

_________________________________________________________________
Fast. Reliable. Get MSN 9 Dial-up - 3 months for the price of 1! (Limited-time Offer) http://click.atdmt.com/AVE/go/onm00200361ave/direct/01/



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.