不要小看对数据库的操作,一个update引起的悲哀

update dbtable for internal_table

notes:if the internal table is empty except primary key,the respective record in table wil be updated emply ,except primary key.

When an internal table itab is specified, the system processes all the rows of the internal table in accordance with the rules for the work area wa. The row type of the internal table must meet the requirements for use in Open-SQL statements. If, in the database, there is no row with the same content of the primary key for a row in the internal table, or if the change would lead to a double entry in a unique secondary key, the respective row is not changed and sy-subrc is set to 4. If the internal table is empty, sy-subrc is set to 0. The system field sy-dbcnt is always set to the number of rows actually inserted.

 

GUI_UPLOAD 函数,filetype 为 'DAT',文件为以 tab键分割的文本文件(txt文件).

 

通过本次事故,以后的工作建议如下:

1,对数据库操作的DML语句,要十分小心,自己要多测试几遍.

2,变更自己严格按照变更执行计划完成,有异议和好的建议,争得需求方的同意,并有文档记录可查.

3,也要求需求方遵守流程.