Re: Is there a way to simulate a trigger when writing to a DSPF?

"Can you please explain what you want to use this support for?  There 
aren't any triggers on display files, but depending on what you want to 
do, I may know of another way to accomplish it."

Scott:

I have database triggers on a few physical files, and I log reads against 
those pf's (with the triggers) to a log file. Problem is I have a few 
interactive programs that do an excessive amount of db reads and then only 
display a handful of those records in subfiles. Mostly they are older 
embedded sql RPGLE programs, where the users can mix and match their input 
field selection criteria (which makes it difficult to create a specific 
logical view for SQL, since there could be x number of conceivable 
combinations of input fields requested by x number of users), and a couple 
other programs that load a subfile in its entirety (rather than page at a 
time). I didn't write them, just inherited them! 

So the RPG/SQL reads the database (and logs every read), and then the RPG 
does a select/omit to determine what to write to the display file. That's 
where I thought it would be cool to do an subprocedure/API type call just 
before the exfmt that would do the logging of only the data being written 
to the display file. 

This would be a great way to track data access for SOX and HIPAA 
compliance.

Mark: I'm reviewing the use of a data queue for this too.

Regards, Jerry

Gerald Kern
IBM Certified AS/400 RPG IV Developer & RPG IV Programmer
MIS Project Leader, Lotus Notes/Domino Administrator
The Toledo Clinic, Inc.
4235 Secor Road
Toledo, OH 43623-4299
Phone 419-479-5535
gkern@xxxxxxxxxxxxxxxx

*****
This email message, including any attachments, is for the sole use of the 
intended recipient(s) and may contain confidential and privileged information. 
Any unauthorized review, use, disclosure or distribution is prohibited. If you 
are not the intended recipient, please contact the sender by reply email and 
destroy all copies of the original message.