IBM DB2

Consultar e manipular dados no IBM DB2

Inserir

AI-generated

Summary

Insert a new row into a specified IBM DB2 table by providing the table name, target columns, and corresponding values.

Inputs

  • Tabela (required) — Name of the target table where data will be inserted.
  • Colunas (required) — Comma-separated column names corresponding to the data values to insert.
  • Dados (required) — Comma-separated values to insert into the specified columns; string values must be enclosed in double quotes.

Output shape

a list of records representing the result of the insert query, typically metadata about the insertion operation

The operation processes input items sequentially, inserting one row per item. On success, returns insert operation results. If multiple items are processed, returns results for each. Errors can be caught and returned in output if 'Continue On Fail' is enabled.

Links

Discussion