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

  Sorry but the short is I do not know of this ability in AS/400 SQL, but 
I have to ask why you are doing this in this manner.  If you use the 
ability of "trigger" programs in the AS/400 you will save a lot of cycles 
and have all the access you are looking for here. 

        JMS

On Mon, 7 Sep 1998, prakash subramanian wrote:

> 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
> 
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
> +---
> | 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
> +---
> 
+---
| 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
+---