Re: Triggers - when you want to eat your cake and have it too ...

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Don,

Can you run your batch programs under a specific user? You could then
program your trace to skip the audit trail for an particular user.

Regards,
Luis
Sent from my Moto G phone. Please excuse my brevity.

On Aug 7, 2017 12:57 AM, "Don Brown" <DBrown@xxxxxxxxxx> wrote:

> Hi All,
>
> I already know the answer to the question but maybe someone has come
> across it previously and come up with an excellent solution.
>
> We load a lot of information from external systems in batch mode.  By
> batch mode I mean we have a header and detail file and there could be
> thousands of detail records to the one header.
>
> We need to implement a quite specific audit over changes to the detail
> records and to do this we are using a trigger.
>
> Works great!
>
> But commonly many of the loaded batches may be deleted and reloaded either
> to cater for change in business rules as part of the load or something has
> changed on the source system.
>
> So when this happens we do physical deletes and the trigger fires and
> saves an audit of the deleted record but in this case we do not want the
> audit so we have another trigger on the header file and if the header is
> deleted we delete the audit records which while that works is very
> inefficient.
>
> So I was just wondering if anyone has come across an efficient way to have
> a trigger write an audit if a single record is maintained or updated but
> not if the entire range of records for a batch is deleted.
>
> Thanks you for any suggestions.
>
>
> Don Brown
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD