Re: Timestamp when a record is updated...

[Rob Berendt <rob@xxxxxxxxx>]

Use a trigger program.  They aren't all that hard.  I use one just to do 
this same thing.  It also records the user who made the change.  This way 
it catches it no matter how they update the file:  my custom green screen 
ap, UPDDTA, PC program, etc.





jocke@fsys.se on 08/19/99 05:00:47 AM
Please respond to RPG400-L@midrange.com@Internet
To:     RPG400-L@midrange.com@Internet
cc:      
Fax to: 
Subject:        Timestamp when a record is updated...

Is there any feature in the database that automaticly sets a
timestamp value whenever a record is updated or added ?

Else we must include z-add timestamp before every updat/write
in all our porgrams :(




+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---


+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---