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

Work Item Generation

Whether this node generates static or dynamic work items. You should generally leave this set to "Automatic" unless you know the node’s work items can be computed statically, or that they need to be generated dynamically.

Dynamic

This node always creates dynamic work items: it waits until the upstream work items are known, and generates new work items from the upstream work items.

Static

This node always creates static work items: it creates the number of work items it thinks it needs based on the parameters (and any upstream static items) before the network runs.

Automatic

If the input is static (a static processor, or a partitioner with only static inputs, or a mapper), this node generates static work items, otherwise it generates dynamic work items.

TOP nodes