分享一下我老师大神的人工智能教程!零基础,通俗易懂!http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识,造福人民,实现我们中华民族伟大复兴!
删除单行:
DELETE <dbtab> [CLIENT SPECIFIED] FROM <wa>."从数据表中删除与<wa>中主键相同的行。
DELETE <dbtab> [CLIENT SPECIFIED]."从数据库删除主键与表工作区<dbtab>中指定主键相同的行。
例:
TABLES SPFLI.
DATA WA LIKE SPFLI.
WA-CARRID = 'AA'.
WA-CONNID = '0064'.
DELETE SPFLI FROM WA.
SPFLI-CARRID = 'LH'.
SPFLI-CONNID = '0017'.
DELETE SPFLI.
删除多行
语法:
DELETE FROM <dbtab> [CLIENT SPECIFIED] WHERE <conditions>.
使用内表删除多行
语法:
DELETE <dbtab> [CLIENT SPECIFIED] FROM TABLE <itab>."如果已处理了内表中所有行,SY-SUBRC置为0.否则为4.如内表为空,SY-SUBRC和SY-DBCNT都为0.
例:
TABLES SPFLI.
DATA ITAB LIKE SPFLI OCCURS 10 WITH HEADER LINE.
ITAB-CARRID = 'UA'. ITAB-CONNID = '0011'.
APPEND ITAB.
ITAB-CARRID = 'LH'. ITAB-CONNID = '1245'.
APPEND ITAB.
ITAB-CARRID = 'AA'. ITAB-CONNID = '4574'.
APPEND ITAB.
DELETE SPFLI FROM TABLE ITAB.