Table Input
Description
Table Input is a step in the Input Plugin for Process Studio Workflows. Table input step is used read and input data from databases using SQL statements.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step name | Specify the name of this step in the workflow workspace. Step name must be unique. |
| Content Tab: | ||
| 1 | Step Name | Specify the name of this step in the workflow workspace. Step name must be unique. |
| 2 | Connection | Select existing Database connection for reading data. |
| 3 | Button: Edit | Click to edit database connection properties. |
| 4 | Button: New | Click this button to create and configure settings of a new database connection. |
| 5 | Button: Wizard | Click to create a new wizard-based database connection. |
| 6 | SQL | Specify SQL statement for reading information from a database connection. |
| 7 | Button:Get SQL select statement | Click Get SQL select statement... to browse tables and automatically generate a basic select statement. |
| 8 | Enable lazy conversion | If checked, unnecessary data type conversions are avoided resulting in performance improvements. |
| 9 | Replace variables in script? | If checked, it allows performing testing with or without performing variable substitutions. |
| 10 | Insert data from step | Select a field in the input stream from which information is expected to come. |
| 11 | Execute for each row? | If checked, it performs data insertion for each individual row. |
| 12 | Limit size | Specify the number of lines to read from the database. Zero (0) means read all lines. |