IBM DB2

Consultar e manipular dados no IBM DB2

Actions4

Atualizar

AI-generated

Summary

Update rows in a specified IBM DB2 table by setting column-value pairs optionally filtered by a WHERE condition.

Inputs

  • Tabela (required) — The name of the table in which to update data.
  • Colunas e Valores — Comma-separated pairs of column=value for the update. String values must be enclosed in double quotes.
  • Condição WHERE — WHERE condition to specify which rows to update. Leave empty to update all rows in the table.

Output shape

a list containing the result of the update query execution for each input item

Returns the native result of the SQL UPDATE query; if multiple items are processed, results are aggregated into a list. Errors may be returned in the output if 'continue on fail' is enabled.

Links

Discussion