sqlsa

declare lup dynamic procedure for sqlsa;
msql="update mma set stock_gd = stock_gd - 10 where m_id like '"+mlike+"%'"
prepare sqlsa from :msql;
execute dynamic lup;
close lup;