I understand what you are asking for. While IBM supplies a
SELECT MYNBR FROM final table (
INSERT INTO QTEMP/DELETEME (MYNBR) VALUES(:x + :z))

you want to be able to do this on an update as well like
SELECT MYNBR FROM final table (
update qtemp/deleteme
set mynbr=mynbr+1 where mykey=:hMykey)

You can submit a requirement and wait for IBM to determine if that is in
the specs and then decide what to return if more than one row is updated,
or if no row is updated.
Or you can try to figure out what you want to do with this number. If all
you are doing is returning a SNDMSG saying "Dude, you're usage count is up
to the point where you should do a cycle count" then there's no reason you
couldn't do that with a trigger.


Rob Berendt




Return to Archive home page | Return to MIDRANGE.COM home page