If you can't find the product or version you're looking for, visit support.ataccama.com/downloads

Wait For SQL Row

The task waits (at the maximum given amount of time) until the specified query returns a result containing at least one row. If the query returns no result set, the task fails immediately. If the result set contains no rows, the task keeps waiting.

Properties

Name

Type

Description

Expression support

Polling Interval (ms)

mandatory

The interval to wait between two checks of the condition. A value higher than zero is required.

expression evaluating to integer

Timeout (ms)

mandatory

The maximum amount of time the task waits for the condition to be true. After this time the task fails (that is, it does not wait anymore even if the condition is only being checked). A value higher than zero is required.

expression evaluating to integer

Query

mandatory

Query to execute over the database; supports variable mappings. For details about variable mapping, see Workflow Variables.

We do not recommend adding comments and other unnecessary parts in the SQL query since it can become unparseable for JDBC drivers (they might not support these items).

semi-expression

Connection Name

mandatory

Name of the database connection.

semi-expression

Sample

<executable class="com.ataccama.adt.task.exec.EwfWaitForSqlRowTask">
    <pollingInterval>200</pollingInterval>
    <timeout>20000</timeout>
    <query>select $#{fieldName} from $#{tableName} where $#{checkColumnName} = ${checkColumnValue}</query>
    <connectionName>derbyDb</connectionName>
</executable>

Was this page useful?