Re: An Automated and effective way to check for when 2 files get out of sync -- MIDRANGE-L

Mike

Either use journaling on the 2 files, or put triggers on them. Journaling gives you a log of changes that you can retrieve and examine. Triggers, besides everything else you can do with them, could build a log the way you want - like write out a record with the time and the pertinent info - like who did it, the data you're interested in, etc. That's all in the journal (up to a point where the data is concerned) but is a little harder to retrieve - only a little. ;-) The triggers can be called either before or after changes.

There's a Redbook call Advanced Database Functions, SG24-4249-02. Chapter 5 is 72 pages on triggers. It's from October 2000 - there's a later one, SG24-4249-03, with a similar title but it does not have the chapter on triggers. If you can't find the first one, let me know offlist and I'll send you a copy attached. It's a little less than 5GB.

HTH
Vern

At 08:11 PM 7/22/2004, you wrote:

HI I have a discrepancy w/ in an inventory item, because someone is able to move it to another season. I would like to put on a watcher to the two files and see when they get changed. Is this done by useing the system auditing, if so, is it a one command thing to do, or more invovled?
Thanks for everything,
Mike

This mailing list archive is Copyright 1997-2026 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.