update ztable set mynumfield=select dec(mycharfld, 11, 2) from qtable where ...