This tool updates a record in a specified table using data from system data variables mapped to column names. The connection string to the database needs to be specified, as well as the name of the Table.
|
Setup |
Description |
|---|---|
|
Build Where Clause for Update Statement |
Configures the database WHERE clause. |
|
Select Table, Map Columns to System Data variables |
Configures the database connection and column mappings. |
|
Table Name |
Contains the database table name. |
|
Where Clause |
Contains the WHERE clause to update a specific record in the database. |
|
Options |
Description |
|---|---|
|
One Record Per Job |
Limits the output to one record per job. |