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

Jerry,

I'll offer my .02 here....consider rewriting the few interactive program you 
have a problem with.

Not only is it the "right" i.e. technically correct solution IMHO, but you 
should end up with better performing interactive applications.

Particularly with SQLRPG program, there's no reason why the program should be 
doing any extra reads or depending on RPG to do select/omit.  Nor should it be 
to difficult to modify.

Additionally, the load-all shouldn't be to hard to change to a page at a time, 
or extending subfile program.

Charles Wilt
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of
> GKern@xxxxxxxxxxxxxxxx
> Sent: Monday, April 04, 2005 3:14 PM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: 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.
>