Execute Query

This task will execute a non-query against ODBC data source. It is typically used for stored procedures, insert, updates and delete commands.

Settings

Query

Required
The SQL Query to be executed.

Parameter Input File

Required
Name of the file containing parameters if using parameterized queries.

Connection

Required
The ODBC Connection to use. See the Connecting to an ODBC Database article if you require more information on how to create/manage connections.

Zynk Settings

See Common Task Settings

Examples

Sample query, which will update the CreditLimit column in the Customers table where the Turnover is greater than 10000:

UPDATE Customers SET CreditLimit = 1000 WHERE Turnover > 10000