RE: triggers in DB2 , V4r5

["Rolf Mittag" <rm@xxxxxxxxxxxx>]

you already have what you need, look at the
journal in your SQL collection, for every delete
operation you have an entry

issue a "DSPJRN yourLibHere/QSQJRN" (QSQJRN is the default name)

you'll see (it's in German so your column headings will look different)
the last line results from the deletion of a record with "5" before
the line you'll see the record itself.

                            Journaleintrage anzeigen

 Journal  . . . . . . :   QSQJRN          Bibliothek . . . . . :   SD

 Auswahl eingeben und Eingabetaste drucken.
   5=Gesamten Eintrag anzeigen


 Ausw.  Folge     Code  Art   Objekt      Bibliothek  Job         Uhrzeit
              49   F     MS   SDCFD0W     SDR440V1    DLYSAV       3:03:55
              50   F     MS   SDCFHD      SDR440V1    DLYSAV       3:03:55
              51   F     MS   SDF2PDP     SDR440V1    DLYSAV       3:03:55
              52   F     MS   SDC4FPP     SDR440V1    DLYSAV       3:03:55
              53   F     MS   SDSYFFP     SDR440V1    DLYSAV       3:03:56
              54   F     MS   SDOUTF      SDR440V1    DLYSAV       3:03:56
              56   R     DL   SDOUTF      SD          ROLF1       10:57:36

hth Rolf

~~~~~~~~~~~~~~~~~~~~~
Dipl.Inf.(FH) Rolf P Mittag
IBM Partner in Development
Leipziger Str. 50
D-69214 Eppelheim
Fon: +49 (6221) 76 78 60
Fax: +49 (6221) 76 80 26
eMl: rm@r-m-e-d-v.de

Diese E-Mail enthalt vertrauliche und/oder rechtlich geschutzte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
irrtumlich erhalten haben, informieren Sie bitte sofort den Absender und
vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte
Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorised copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.


-----Original Message-----
From: midrange-l-admin@midrange.com
[mailto:midrange-l-admin@midrange.com]On Behalf Of
santoshp@lot.tatasteel.com
Sent: Saturday, September 22, 2001 7: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.