Parameterized DB Query Reader

This node runs SQL queries in the connected database restricted by the possible values given by the input table. It establishes and opens a database access connection from which to read data and restricts each SQL query so that only rows that match the possible values from the input table are retrieved.

Options

Settings

SQL Statement

Enter the SQL-like query here, for example SELECT * FROM table. If the table place holder isn't changed, then it will be replaced with the query from the database connection. Constant values and any identifier from the database column list, column list, flow variable list can be used in WHERE statement.

Database Metadata Browser

The Database Metadata Browser allows you to browse the database metadata and to select a table or view. Click the Refresh button to re-fetch the metadata from the database. The data is grouped by type. By clicking on an entity it shows contained elements. To select a table or view select the name and click OK or double click the element. To search for a particular table or view name enter the name or parts of the name into the search field and click Search. The drop down box allows you to further narrow down the result by type e.g. schema or table. To reset the search filter click Reset.

Database Column List

The list contains the columns that are available in the connected database table. Double clicking any of the entries will insert the respective identifier at the current cursor position (replacing the selection, if any).

Column List

The list contains the columns that are available in the input table. Double clicking any of the entries will insert the respective identifier at the current cursor position (replacing the selection, if any).

Flow Variable List

The list contains the flow variables that are currently available at the node input. Double clicking any of the entries will insert the respective identifier at the current cursor position (replacing the selection, if any).

Fail on error

If checked, then the node will fail if there is any error. Otherwise, the node will continue executing and all errors will be collected in the second output table.

Append input columns

If checked, then the columns from the input table will be appended to the output table. Only columns that are used in the looping SQL statement will be appended.

Retain all columns

If checked, then all columns including columns that are not used in the looping SQL statement will be appended to the output table.

Include empty results

If checked, then all empty results will be appended to the output table and represented as Missing Cell. All input rows will be retained.

Input Type Mapping

Mapping by type

Select an SQL type for the given KNIME data types.

Output Type Mapping

Mapping by type

Select a KNIME data type for the given SQL types.

Views

This node has no views

Workflows

• No workflows found

Links

• No links available

Developers