Entering content frame

Background documentation Search Conditions for UPDATE Statements Locate the document in its SAP Library structure

If you use UPDATE statements, the following restriction applies to the use of search conditions.

If the new value of a column is calculated in an arithmetical expression, an inversion of this column, that is, the corresponding index, cannot be used during the search.

Example

UPDATE <table_name> SET columnx = columnx + 3 WHERE columnx IN (100, 103, 106, 109, 112)

This SQL statement can lead to erroneous results, if the inversion lists were gradually processed with the values 100, 103, 106, 109, and 112.

You should also consider this factor when using FOR UPDATE in the SELECT statement.

 

 

Leaving content frame