ABAP Keyword Documentation →  ABAP - Reference →  Processing External Data →  ABAP - Database Accesses →  Open SQL →  Open SQL - Write Accesses →  UPDATE dbtab 

UPDATE dbtab - set_expression

Short Reference

Other versions: 7.31 | 7.40 | 7.54

Syntax

... [col1 = f1 col2 = f2 ... ] 
    [col1 = col1 + f1 col2 = col2 + f2 ...] 

    [col1 = col1 - f1 col2 = col2 - f2 ...] 
    [(expr_syntax1) (expr_syntax2) ...] ... . 

Extras

1. ... col = f
2. ... col = col + f

3. ... col = col - f
4. ... (expr_syntax)

Effect

Change Expressions for the Addition SET of the Statement UPDATE.

Addition 1

... col = f

Effect

Assigning a Value For col, columns of the database table given in target or in the stated view dbtab can be specified using a column name comp or dbtab~comp. For f, data objects of the ABAP program or a column name dbtab~comp of another column in the database table can be used.

The statement UPDATE assigns the content of f to the columns col in all the rows defined by the WHERE condition. If the data types are not compatible, they are converted as follows:

• When assigning a data object that is not a reference variable for a LOB handle, the content is converted, if required, to the ABAP data type appropriate to the data type of the column (and in accordance with the conversion rules). Any errors in the conversion raise the appropriate non-handleable exception.
• When assigning a data object that is a reference variable for a LOB handle, the column col must be a LOB with an appropriate type. If the reference has a writer stream type, then a writer stream is created. In this case of a type for a locator: this must exist and is used as a source. For details, see LOB handles.
• When assigning a different column, the content is converted, if required, in the database system. Whether a conversion is possible and the conversion rules are specific to the database system. Any errors in the conversion raise the handleable exception CX_SY_OPEN_SQL_DB.
  

In the assignment, the assigned value must fit in the value range of the column. Otherwise the handleable exception CX_SY_OPEN_SQL_DB is raised. This applies in particular for:

• Assignments to numeric columns
• Assignments to columns of the type SSTRING, STRING, or RAWSTRING. The assigned content must not be longer than the maximum length of the columns in the database structure. This length can be determined using the predefined function dbmaxlen.
  

If a column is specified for f, changes to this column that are made in the same UPDATE statement are ignored during the assignment.

If a column col appears in multiple change expressions, the last change expression applies.

Addition 2

... col = col + f

Effect

Addition of a value. For col and f, the same applies as for the assignment of a value. However, col must have a numeric data type. The data types DF16_RAW, DF16_SCL, DF34_RAW, and DF34_SCL are not permitted.

The statement UPDATE adds the value of f to the content of the column col, in all the rows defined by the WHERE condition. Otherwise, the same rules apply as for the assignment of a value.

Addition 3

... col = col - f

Effect

Subtraction of a value. For col and f, the same applies as for the assignment of a value. However, col must have a numeric data type. The data types DF16_RAW, DF16_SCL, DF34_RAW, and DF34_SCL are not permitted.

The statement UPDATE subtracts the value of f from the content of the column col, in all the rows defined by the WHERE condition. Otherwise, the same rules apply as for the assignment of a value.

Addition 4

... (expr_syntax)

Effect

Dynamic specification of change expressions. A change expression can be specified as a parenthesized data object expr_syntax that, when the statement is executed, either contains the syntax of one or more static change expressions or is initial. The data object expr_syntax can be a character-like data object or a standard table without secondary table keys and with a character-like data object. The syntax in expr_syntax is not case-sensitive, as in ABAP Editor. When specifying an internal table, you can distribute the syntax over multiple rows.

If expr_syntax is initial when the statement is executed, the change expression is ignored.

Note

If expr_syntax is an internal table with a header line, the table body is evaluated and not the header line.