Sorry forgot to mention that the stored procedure must be an SQLnot an RPG Program

["Giri Gopal" <GiriGopal@xxxxxxxxxx>]

Hello:

I am very sorry. I forgot to mention that the stored procedure should be in
SQL and not an RPG program.

Once again I am sorry.

Thanks
GG


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Scott Mildenberger
Sent: Wednesday, February 26, 2003 4:57 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Question about calling a stored procedure in a trigger


I'm not sure what a stored procedure has to do with
this.  You just need a trigger program, there should
be many examples in the archives.  You then compare
the before and after values for the field in question
and then write a record to the other file if they
change.

Scott Mildenberger

--- Giri Gopal <GiriGopal@xxxxxxxxxx> wrote:
>  Hello:
>
> I am creating a new table called TRANS. I want to
> capture updates to a
> certain column (ORD_NUM). I am planning to put a
> trigger on TRANS table for
> a Update After.
>
>  Now the question is what would my stored procedure
> look like?, I mean the
> actual code. I need to make sure that the change is
> only to the column
> (ORD_NUM). I need   to compare the before and after
> image of the trigger
> buffer and then write to a new table called
> TRANS_ORD.
>
>


__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.