DB2触发器中怎么执行动态SQL，并且得到影响行的返回值？

[qq_343194731]

SET v_sql =  'UPDATE M_MONEY_TOTAL_BANKIN SET MONEY_REAL' ||'= MONEY_REAL + ' || NEW.CASH ||
                   ' WHERE NET_NO = ''0'||'LEFT('||NEW.PLAZAID||',1)'' AND PLAZ_NO=''RIGHT('||NEW.PLAZAID||',2)'' AND MID='||NEW.MID||
                   ' AND VER_NO='||140||' AND DHM='''||NEW.CLEAR_TARGET_DATE;
          PREPARE S1 FROM v_sql;
          EXECUTE S1;

          GET DIAGNOSTICS v_ret = ROW_COUNT;

我这样写，会报错，错误码42601，语法错误。请问应该怎么写才对？

[qq_343194731]

UPDATE M_MONEY_TOTAL_BANKIN
      SET MONEY_REAL = (MONEY_REAL + NEW.CASH)
    WHERE     NET_NO = '0' || LEFT (NEW.PLAZAID, 1)
          AND PLAZ_NO = RIGHT (NEW.PLAZAID, 2)
          AND MID = NEW.MID
          AND VER_NO = 140
          AND DHM = NEW.CLEAR_TARGET_DATE;

   --DB2写法 返回影响行
   --execute v_sql;
   --PREPARE S1 FROM v_sql;
   --EXECUTE S1;

   GET DIAGNOSTICS v_ret = ROW_COUNT;

这样写就可以了。