Updating Partition Key with Before Trigger

Well, in case anyone is interested, I did try it. It does seem to
work, I am surprised. I would have expected the before trigger to be
executed after the insert was routed to a partition. Obviously, that
is not exactly what it happening.

Jack

mirof007 DeleteThis @gmail.com wrote:
 > Why not simply try it? Yes, this is allowed both in before and in
 > after triggers. Has been since DB2 UDB for L/U/W Version 8.1.
 >
 > Regards,
 > Miro<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Updating Partition Key with Before Trigger 

<jbaker DeleteThis @marketron.com> wrote in message
news:1108147376.688951.106940@l41g2000cwc.googlegroups.com...
 > Well, in case anyone is interested, I did try it. It does seem to
 > work, I am surprised. I would have expected the before trigger to be
 > executed after the insert was routed to a partition. Obviously, that
 > is not exactly what it happening.
 >
 > Jack
 >
Somehow I am thinking this is not very efficient since the partition that
gets the row, then has to then send it to another partition. There are
better ways to force data to be loaded on a specific partition, unless
performance is not at all an issue (in which case I wonder why you are using
DPF).<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Updating Partition Key with Before Trigger