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.