Execute Scalar Query

This task will execute a scalar query (a query which returns a single result) on an ODBC data source. The result can be accessed by the next task in the workflow using the 'Output from the previous task' option.

To run a query which can return multiple rows and/or columns from the database, use the Execute Select Query task instead.

Settings

Query

Required
The SQL query to be executed. See below for an example.

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

You can find an example of how to use this task in the Using the ODBC Connector tutorial.

Sample query, which will select the sum of the Balance column from the Accounts table:

SELECT SUM(Balance) FROM Accounts