×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
On point 3, I haven't tested it, but I see no reason why SQL trigger
wouldn't work against the PF.
Celebrating 10-Years of SQL Performance Excellence
http://centerfieldtechnology.com/training.asp
-----Original Message-----
Subject: Triggers
I have a PF where when a certain field is changed I wish to write a copy
of the record to another file. Obviously, I could do this in the RPG pgm
but prefer to not change the pgm.
I have been reading about triggers and would like some confirmation on a
couple things.
First, there are two kinds of DB triggers, PF and SQL table triggers.
Second, the PF trigger cannot detect an update to a specific field, while
the SQL trigger can execute when a change in a specific column is
detected.
Third, since my file is a PF and not an SQL table, I cannot use the SQL
trigger and must use the ADDPFTRG.
Fourth, if I were to change my PF to an SQL table, an SQL trigger would be
a good choice to address my issue.
Any other suggestions as to how to handle my situation are also welcome.
Thanks.
midrange.com
