RE:dentifying who deleted records - trigger programs

["Terry Anderson" <terrya@xxxxxxxxxxxx>]

Blake,
You should be able to retrieve the user by doing something like:

D  USERID         S             10    INZ(*USER) 

Then write the variable USERID to your file.

Here is an article I found on how to tell what program caused your
trigger to fire.

http://www.tylogix.com/Articles/TriggerTechniques.htm#Trigger_Firing_Pro
gram


I am curious about something though.  I am assuming that you will be
writing this information to a file.  Won't you run into the same storage
problems with the file that you would with a journal?  I know you said
that this would be for deleted records, but don't the auditors want to
know about any change to a record?  We are a privately held company so I
know very little about sox requirements. 



Terry Anderson 
Programming Manager 
Citation Corporation 
Switchboard 1.251.867.5481 ext 212 
Direct Line 1.251.809.2312 
Fax 251.867.0525 
Cell  1.251.363.4975 

 

> > message: 2
> > date: Thu, 13 Nov 2008 09:35:54 -0500
> > from: Blake.Moorcroft@xxxxxxxxxx
> > subject: RE: Identifying who deleted records - trigger programs
> >
> > The use of the journals for data retrieval is being 
> > investigated by another developer.  However, there are 
> > considerations about how long the data in the journals is 
> > available due to the volume of data being processed.  The 
> > auditors are looking for control over one file and 
> > governmental regs require stored data to be *immediately* 
> > available for a period of no less than 7 years (and 
> > displeasing a government auditor who can yank your operating 
> > license immediately is not conducive to business operations).
> > The journals that would encompass this file also contain 
> > record changes on close to 90 other files.  While it would 
> > be a preferred option, it may not be a viable option.
> >
> > So, to cover the bases, I'm assigned to check the option of 
> > triggers, which leads back to the original question of user 
> > and program identification from inside a trigger event.
> >
> > Have a good day.
> >
> >
> > Blake Moorcroft
> > Developer - Corporate
> > Russell A. Farrow Limited
> > 1980 Ambassador Drive, PO Box 333, Windsor, Ontario N9C 3R4
> > Bus: 519-966-3003 ext. 566, Fax: 519-966-9870 
> > blake.moorcroft@xxxxxxxxxx