Configuration
The Configuration tab has the following fields.
Field |
Global Var? |
Description |
Name |
No |
The name to appear as the label for the activity in the process definition. |
Description |
No |
Short description of the activity. |
JDBC Connection |
Yes |
Path to the shared configuration resource containing the JDBC connection information. For more information about JDBC resources, see JDBC Connection . |
SQL Statement |
Yes |
The SQL SELECT statement to perform in the database. You can use a wizard to build the query for the desired database. For more information about using the Query Designer wizard, see Query Designer. |
Timeout (sec) |
Yes |
Time (in seconds) to wait for the query to complete. If the query does not complete in the given time limit, an error is returned. |
Maximum Rows |
Yes |
The maximum number of rows to retrieve. To retrieve all rows, specify 0. |
Prepared Parameters |
No |
For a description of this field, see Prepared Parameters. |