By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,752 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

?example after insert trigger doing update on inserted row?

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.