ABAPDELETE_DBTAB - DELETE DBTAB

BAL_S_LOG - Application Log: Log header data   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.

DELETE dbtab

Short Reference

Syntax

DELETE { {FROM target [WHEREsql_cond]}
       | {target FROMsource} }.

Effect

The statement DELETE deletes one or more rows from the database table specified in target.The rows that are to be deleted are declared either in a WHERE condition sql_condor with data objects in source.

System Fields

The statement DELETE sets the values of the system fields sy-subrc and sy-dbcnt.

sy-subrc	Meaning
0	In the declaration of a WHERE condition, at least one row was deleted. Inthe declaration of a work area source, the declared row was deleted. In the declaration of aninternal table in source, all declared rows were deleted or the internal table is empty. If no conditions were declared, all lines were deleted.
4	In the declaration of a WHERE condition or the declaration of a work areain source, no rows were deleted. In the declaration of an internal table in source, alldeclared rows were deleted. If no conditions were declared, no lines were deleted, since the database table was already empty.

The statement DELETE sets sy-dbcnt to the number of deleted rows.

Note

The rows are deleted permanently from the database table in the nextdatabase commit. Until then, you can cancel the deletion using a database rollback. The statement DELETE sets adatabase lock until the next database commit or database rollback. If used incorrectly, this can lead to adeadlock.

The number of rows that can be deleted within a database LUW in the tables of a database has a specific restriction for each database, as each database system can only manage a limited amount of data in the rollback area, and a limited number of locks.

CPI1466 during Backup   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.


Length: 3575 Date: 20120522 Time: 045235     triton ( 182 ms )