If you can't find the product or version you're looking for, visit support.ataccama.com/downloads
Execute SQL
Executes an SQL query. The task does not process the result in any way, therefore it is suitable for commands returning no result, such as inserts or updates.
Properties
Name | Type | Description | Expression support | ||
---|---|---|---|---|---|
Connection Name |
mandatory |
Connection name to use for query invocation. Connection names are taken from Runtime Configuration. |
semi-expression |
||
Query |
mandatory |
Query to execute.
|
semi-expression |
Sample
<executable class="com.ataccama.adt.task.exec.EwfSqlTask">
<connectionName>name</connectionName>
<query>insert into $#{tableNameVar} (col1, col2, col3) values ( ${someIdValue}, ${ ewfGetTaskVariable('taskName','varName') }, 1)</query>
</executable>
Variables usage
Note that this example also illustrates the usage of both variables in SQL queries. For more information, see Workflow Variables.
Was this page useful?