RE: triggers in DB2 , V4r5

Try this link (watch out - it is long):

http://publib.boulder.ibm.com/pubs/html/as400/v4r4/ic2924/info/db2/rbafomstr
zahftri.htm#HDRRZAHFTRK

or go to the InfoCenter and search for "Cobol trigger":

http://publib.boulder.ibm.com/pubs/html/as400/v4r4/ic2924/info/INFOCENT.HTM


Good Luck,
Terry

-----Original Message-----
From: santoshp@lot.tatasteel.com [mailto:santoshp@lot.tatasteel.com]
Sent: Saturday, September 22, 2001 1:52 AM
To: midrange-l@midrange.com
Subject: Re: triggers in DB2 , V4r5



If any of u can , plz send me an example of a trigger program in COBOL.

my reqd is :

whenever a row is deleted from a table..., an audit table should get that
row inserted into it...

santosh.
i know only cobol....


Signature......................

e- mail at :  santoshp@lot.tatasteel.com
ITS, Tata Steel.
Jamshedpur, India.
Tel : 842134 (O) , 200279 (R).



                    santoshp@lot.tatast
                    eel.com                    To:
midrange-l@midrange.com
                    Sent by:                   cc:
                    midrange-l-admin@mi        Subject:     triggers in DB2
, V4r5
                    drange.com


                    22/09/01 08:48
                    Please respond to
                    midrange-l







hi , i am new to this forum.. we had recently acquired v4r5 machines....
I guess triggers can be written in thsi for SQL deletes or updates on
table...

plz tell where where to find material on how to do it...
or otherwise , plz explain writting a  trigger here only. ....



santosh.

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.




_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.