Icon

Dynamic SQL and Parameter Passing

Dynamic SQL and parameter passing
Note - DB Query and Parameterized DBQuery Reader nodes will fail if you includesingle $ signs in comments with prefixingwith a \ to escape them, as it appears tomisinterpret them as if they are actualvariables. Select tableTEST_TABLE_1Dynamic queryusing conditions based on values inconditions tableand flow variableConditional values tablefor use with Parameterized DB Query ReadDynamic queryusing flow-variableNode 11sql-age-valueDynamic queryDynamic queryConnect H2 databaseSample DataNAME, AGE, COUNTRYInsert sample datainto H2 databasetableTEST_TABLE_1Dynamic queryusing flow-variableto define part of the sql query(the column list) and values in the where clauseString flow variable definingcolumns to be returndDynamic queryusing flow-variableto define part of the sql queryNode 24Node 25Node 26 DB Table Selector ParameterizedDB Query Reader Table Creator DB Query DB Reader IntegerConfiguration ParameterizedDB Query Reader ParameterizedDB Query Reader H2 Connector Table Creator DB Writer DB Query StringConfiguration DB Query StringConfiguration DB Reader DB Reader Note - DB Query and Parameterized DBQuery Reader nodes will fail if you includesingle $ signs in comments with prefixingwith a \ to escape them, as it appears tomisinterpret them as if they are actualvariables. Select tableTEST_TABLE_1Dynamic queryusing conditions based on values inconditions tableand flow variableConditional values tablefor use with Parameterized DB Query ReadDynamic queryusing flow-variableNode 11sql-age-valueDynamic queryDynamic queryConnect H2 databaseSample DataNAME, AGE, COUNTRYInsert sample datainto H2 databasetableTEST_TABLE_1Dynamic queryusing flow-variableto define part of the sql query(the column list) and values in the where clauseString flow variable definingcolumns to be returndDynamic queryusing flow-variableto define part of the sql queryNode 24Node 25Node 26DB Table Selector ParameterizedDB Query Reader Table Creator DB Query DB Reader IntegerConfiguration ParameterizedDB Query Reader ParameterizedDB Query Reader H2 Connector Table Creator DB Writer DB Query StringConfiguration DB Query StringConfiguration DB Reader DB Reader

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: @takbb Brian Bates
Created at: 2021-06-04
On NodePit since: 2021-06-04
Last update: 2024-05-01
Created with KNIME version: v4.3.3
Tags: Parameterized DB Query ReaderDB QueryDynamic SQLParameter Passing SQLSQL

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!