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

Execute SQL

Execute SQL icon

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?