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.

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

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>

Predefined variables

None.

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?