Parameterized Database Query (deprecated)

This node is part of the deprecated database framework. For more information on how to migrate to the new database framework see the migration section of the database documentation .

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.

Input ports

1. Type: Table
   Data with possible values
   Data column with possible values used to constrain the database SQL query
2. Type: Database Query
   Database query connection
   A database query connection that will be used to connect to the database

Output ports

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