This tool performs a table lookup and translation using a field from the System Data Job Object. The connection string to the database needs to be specified, as well as the name of the Table.
For the Database Lookup tool, there must be Data Fields entered into Infiniworx. There are two connectors - Found and Not Found - for this tool.
|
Options |
Description |
|---|---|
|
Table Name |
Contains the database table name. |
|
WHERE Clause |
Enter an SQL statement to be used as the WHERE clause. |
|
Translation |
Maps the database columns to data fields. |
|
Simple SQL |
Description |
|---|---|
|
If No Recordset |
When using an SQL clause that contains only a single variable, this determines the behavior if the recordset is not found. |