RE: triggers

If you want a write up on triggers go to site -
http://publib.boulder.ibm.com/pubs/html/as400/online/v3r7eng.htm
<http://publib.boulder.ibm.com/pubs/html/as400/online/v3r7eng.htm>  and
search in bookshelf :QBJAYC04  for TRIGGERS.

One usage of triggers is in the cases where people use UPDDTA for updating a
database. Suppose you want an audit trail. In that case your idea of
creating a program may not work.

Another prominent usage was in the Y2K patches done to applications. Here an
additional field was created in the database of length 8 for an existing
date field of length 6. Then a trigger was used to update this field on an
update to the field of length 6.  The field of length 8 was returned to the
program whenever field of length 6 was to be used for calculations.


Vijosh A 
Senior Consultant
Systems & Software 
SEEPZ, Bombay, INDIA.
Email : <vijosha@alfuttaim.co.ae>


        -----Original Message-----
        From:   Srinivasan Lakshmi Narasimhan [SMTP:narasu@wipsys.soft.net]
        Sent:   Monday, December 06, 1999 7:54 AM
        To:     RPG400-L@midrange.com
        Subject:        Re: triggers


        hi,

        kindly provide me the actual usage/need for triggers. instead i can
go for a
        program with logic steps of insert/update/delete of records in the
relative files
        as soon as access to parent file is done. is it right /efficient
way?

        s.lakshmi narasimhan


        +---
        | 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
+---