DELETE DBTAB

Reference

Syntax

DELETE { {FROM {dbtab|(dbtab_syntax)} [CLIENT SPECIFIED]
         [WHERE sql_cond]}
       | {{dbtab|(dbtab_syntax)} [CLIENT SPECIFIED]
         FROM { wa|{TABLE itab} } } }.

Effect

Deletes rows from a database table.

Additions

• FROM {dbtab|(dbtab_syntax)}
  Specifies the database table statically or dynamically.
  
  
• CLIENT SPECIFIED
  Deactivates automatic client handling.
  
  
• WHERE sql_cond
  Uses a sql_cond condition to specify the rows that are to be deleted.
  
  
• FROM { wa|{TABLE itab} }
  Specifies the rows that are to be deleted by matching them with the key values of a work area wa or the rows of an internal table itab.