UPDATE

Reference

Syntax

UPDATE {dbtab|(dbtab_syntax)} [CLIENT SPECIFIED]
       { { SET [col1 = f1 col2 = f2 ... ]
               [col1 = col1 + f1 col2 = col2 + f2 ...]
               [col1 = col1 - f1 col2 = col2 - f2 ...]
               [(expr_syntax1) (expr_syntax2) ...]
               [WHERE sql_cond] }
       | { FROM wa|{TABLE itab} } }.

Effect

Changes rows in a database table.

Additions

• {dbtab|(dbtab_syntax)}
  Specifies the database table statically or dynamically.
  
  
• CLIENT SPECIFIED
  Switches off automatic client handling.
  
  
• SET col1 = f1 col2 = f2 ... - Assigns to columns col1, col2, ... the contents of f1, f2 ...
  
  
• SET col1 = col1 + f1 col2 = col2 + f2 ... - Adds the contents of f1, f2, ... to columns col1, col2, ...
  
  
• SET col1 = col1 - f1 col2 = col2 - f2 ... - Subtracts the contents of f1, f2, ... from columns col1, col2, ...
  
  
• SET (expr_syntax) - Dynamic specification of a change in expr_syntax.
  
  
• WHERE sql_cond
  Specifies the lines to be changed using a condition sql_cond.
  
  
• {FROM wa}|{FROM TABLE itab}
  Overwrites lines with a work area wa or with the rows of an internal table itab.