467,198 Members | 1,205 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,198 developers. It's quick & easy.

?example after insert trigger doing update on inserted row?

I am looking for an example 'after insert' trigger that performs an update
to a column in the master table. For example, I have an 'orders' table that
contains a 'PartNum' column. I would like to translate the part number
coming in on the inserted record to a new part number by doing a lookup in a
second table 'PartNumConversion' table that contains 2 columns 'oldPartNum',
'newPartNum'. I would also like to log the oldPartNum and NewPartNum to a
history/change table for logging purposes. Any example doing something
similiar would help. Environment DB2UDB 8.1,WinXP
Thanks, Bill

Nov 12 '05 #1
  • viewed: 3374

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by takilroy@yahoo.com | last post: by
3 posts views Thread by teddysnips@hotmail.com | last post: by
3 posts views Thread by jazpar | last post: by
7 posts views Thread by anu b | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.