Re: using equivalent of NEW and OLD keywords in DB2/400 SQL

A *BEFORE *INSERT trigger doesn't do the job?  I am curious why it
doesn't, just for my own education.


In <19980907134323.5824.qmail@hotmail.com>, on 09/07/98 
   at 06:43 AM, "prakash subramanian" <prakashsubramani@hotmail.com> said:

>Hi all,

>I've got a SQLRPG program, which is a trigger program. This program 
>checks whether any other program has issued an update or insert to a 
>database table that I maintain and immediately TRIGGERS a message. The 
>problem is I cannot determine when a new row is inserted. We have NEW 
>and OLD keywords in Oracle and other languages. I want to know the 
>equivalent of these keywords in DB2/400. Also is there any other way of 
>my accomplishing the said task.

>                                 Thanks in advance

>Prakash                                 prakashsubramani@hotmail.com

-- 
-----------------------------------------------------------
boothm@ibm.net
Booth Martin
-----------------------------------------------------------

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