Parameterized DB Query Reader

This node runs SQL queries in the connected database restricted by the possible values given by the KNIME input table. It restricts each SQL query so that only rows that match the possible values from the input table are retrieved.

Input ports

1. Type: Table
   Data table with possible values
   KNIME data table with possible values used to constrain the database SQL query.
2. Type: DB Data
   DB Data
   DB Data that will be used during query execution.

Output ports

1. Type: Table
   Result Table
   KNIME data table with the result from the database and optionally the data columns from the input table.
2. Type: Table
   Error Table
   Table with error message if any, otherwise empty table.