UPDATE changes the content of one or more rows of the database
table specified in
The entries in
source determine which columns of which rows are changed, and how they are changed.
|2||If a LOB handle structure with a component forwriter streams or a referencevariable for writer streams was specified after
sy-dbcnt to the number
of changed rows. If an overflow occurs because the number or rows is greater than 2,147,483,647,
sy-dbcnt is set to -1. If
sy-subrc is 2,
sy-dbcnt is also set to the value -1 (for undefined).
- The changes are committed to the database by the next database commit. Until that point, they can still be undone using a database rollback The current isolation level defines whether the modified data can be read into other database LUWs before or only after the database commit.
UPDATEsets a database lock until the next database commit or rollback. If used incorrectly, this can produce deadlock.
- The number of rows that can be modified in the tables of a database within a database LUW is limited, since a database system can only manage a limited amount of locks and data in the rollback area.
UPDATEcannot be applied to the system table TRDIR.