Since | 17.5 |
Output node for create a SQL INSERT query.
Parameters
Input
Driver
Module name of the database driver to use.
Database
Database connection string.
Table Name
The SQL table name.
Columns
This is the number of columns.
Column Name
The column name.
Data Tag
This is the data tag used for the column.
Custom Query
Override Query
If true, the query will be defined by the “Query” parameter instead of generating one.
Query
If “Override Query” is true, this is the SQL query to be executed.
Processor
Generate When
Determines when this node will generate work items. You should generally leave this set to “Automatic” unless you know the node requires a specific generation mode, or that the work items need to be generated dynamically.
All Upstream Items are Generated
This node will generate work items once all of the input nodes have generated their work items.
All Upstream Items are Cooked
This node will generate work items once all of the input nodes have cooked their work items.
Each Upstream Item is Cooked
This node will generate work items each time a work item in an input node is cooked.
Automatic
The generation mode is selected based on the generation mode of the input nodes. If any of the input nodes are generating work items when their inputs cook, this node will be set to Each Upstream Item is Cooked. Otherwise, it will be set to All Upstream Items are Generated.