RE: EOFW not resume

["Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>]

>The statement above would only be fired if a record were updated AND
the
>record contents changed...

I'll go one better, look at using SQL to create the trigger. You can
specify what FIELD(s) to watch for a change. 

----Code----

Create trigger OSChange after update of status on GWRQCTP
referencing new as NowIs
for each row mode db2sql

/* I like to be able to see compiled trigger code */
set option output=*print

/* SQL will bail at this point is the new status value <> 'OS' */
When (NowIs.Status = 'OS')

BEGIN

/* Declare field(s) needed to hold data you want to pass to your pgm */
Declare KeyField int;

/* Load up the field(s) with data from changed row. */
Set KeyField = NowIs.KeyField;

/* Call program to do something. Or use SQL statements here if you can.
*/
/* I'd love to use CALL YourPgm(NowIs.KeyField), but SQL won't allow it.
*/
CALL YourPgm(KeyField);

END


----End Code----


------------
Walden H Leverich III
President & CEO
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)