DB Row Manipulator

This node runs SQL commands e.g. INSERT, UPDATE, DELETE in the connected database using the values given by the KNIME input table. The values of the selected columns are used in the command resulting in each row of the KNIME input table creating its own command that is send to the database with the corresponding values for execution.

Input ports

1. Type: Table
   Data to use during database statement execution.
   KNIME data table with the data rows to be used during statement execution.
2. Type: DB Session
   DB Connection
   DB Connection to the database.

Output ports

1. Type: Table
   Input Data with Manipulation Status
   Input KNIME data table with additional columns providing the number of affected rows in the database and warnings, if checked in the dialog.
2. Type: DB Session
   DB Connection
   DB Connection to the database.