IBM DB2

Consultar e manipular dados no IBM DB2

Excluir

AI-generated

Summary

Delete rows from a specified IBM DB2 table using an optional WHERE condition to filter which rows are removed.

Inputs

  • table (required) — Name of the table from which to delete rows.
  • where — Optional WHERE condition string to specify which rows to delete; if left empty, all rows in the table are deleted.

Output shape

a list containing the result object(s) from the delete SQL execution for each input item processed

If multiple items are processed, returns an array of results corresponding to each item. Errors can be returned in the output if 'Continue On Fail' is enabled.

Links

Discussion