Re: SQL on V5R1

I did read the whole message. I knew he was on 5.1.

I was commenting on your suggestion of a before insert trigger and the
downside of it. One being the lack of getting the value. Perhaps if I
had dropped the first part of the identity_val_local you might have made
it to the second part suggesting "select from insert" (which you snipped).
I was hoping that might be able to read a value inserted by a before
insert trigger. But I believe that support for "select from insert"
didn't come out until later also.


Rob Berendt