此博客为原创博客,都是个人工作经历所得,转载请注明出处

20170322 低级却致命的错误

MODIFY 

MODIFY dbtab 语法图

Syntax

MODIFY target FROM source.

Effect

The MODIFY statement inserts one or more rows specified in source in the database table specified in target, or overwrites existing rows. 

 

 MODIFY ZMLSCP_LOG002 FROM TABLE OT_FINISHED.
    IF SY-SUBRC EQ 0.
     COMMIT WORK AND WAIT .
    ELSE.
     ROLLBACK WORK.
    ENDIF.

 

BREAK-POINT.
*&s4.modify into ZLOG
  IF OT_FINISHED[] IS NOT INITIAL.
    MODIFY ZMLSCP_LOG002 FROM OT_FINISHED[].
    IF SY-SUBRC EQ 0.
      COMMIT WORK AND WAIT .
      DESCRIBE TABLE OT_FINISHED LINES L_TABIX.
      O_STATU = 'S'.
      O_MSG   = '成功存入ZMLSCP_LOG002表' && L_TABIX && '条记录!'.
    ELSE.
      ROLLBACK WORK.
      O_STATU = 'E'.
      O_MSG   = '数据存入ZMLSCP_LOG002表失败!'.
    ENDIF.
  ENDIF.

 

posted @ 2017-03-22 10:59  Rainystuday  阅读(228)  评论(0)    收藏  举报