RE: Monitoring for Database Updates.

[Chris Bipes <ChrisB@xxxxxxxxxxxxxxx>]

We have a generic trigger that dumps the entire input data structure to a
file, one field varying length and 4096 bytes max record length.  You then
have the fixed 96 bytes, original data and changed data.  We then process
this dumped data with a background service job to audit, log, ......  Modify
your existing trigger to dump the data before or after their existing
functions.

Christopher K. Bipes            mailto:ChrisB@Cross-Check.com
Sr. Programmer/Analyst          mailto:Chris_Bipes@Yahoo.com
CrossCheck, Inc.                http://www.cross-check.com
6119 State Farm Drive           Phone: 707 586-0551 x 1102
Rohnert Park  CA  94928         Fax: 707 586-1884



-----Original Message-----
From: Colin Williams [mailto:Williamsc@technocrats.co.uk]
Sent: Thursday, July 29, 1999 1:26 AM
To: 'MIDRANGE-L@midrange.com'
Subject: RE: Monitoring for Database Updates.


The files I want to look at may have existing triggers, which I cannot
overwrite.
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---