Definition

Specify a label for this query.

Specify the SQL statement to be executed. Any valid SQL statement that is supported by the target database server is allowed. Some example statement types include - SELECT, INSERT, UPDATE, DELETE, CALL, CREATE etc. An easy to use graphical tool is provided to build SELECT statements. Click on the '..' button to launch the SQL Wizard.

Specify a variable of type RowSet which should be fed as input to the SQL Statement being executed. For example, ${variableName}. The specified SQL Statement will be executed once per each row in this RowSet. This is specifically used to insert or update multiple records which are read from a different data source such as a flat file or another database.

If desired, specify the name of a variable which contains the result of the statement execution. The type of this variable is list of objects. The type of object depends on the SQL statement. For SELECT statements, the type of the object is RowSet, and for all other statements, the type of the object is a number which contains the number of records affected, if any.

If desired, specify the name of a variable which contains the result of the selected statement execution. The type of this variable depends on the SQL statement. The RowSet Output Variable contains the result of a statement execution. The type of this variable is RowSet. It contains the first RowSet corresponding to a selected or a stored procedure.

Specify the value that should be used as a replacement for null values that are in the Input RowSet. This value is ignored if the specified SQL statement is a SELECT statement. This value can also be overridden on an individual parameter.

Specify whether or not to create a scrollable RowSet. This attribute is only applicable for queries that return a result set. A scrollable RowSet can be traversed in both forward and reverse directions, thus allowing it to be re-used several times across multiple tasks. A non-scrollable RowSet can only be used once. By default, a scrollable RowSet will be created and should be adequate for most scenarios. Only configure this option if you are sure a non-scrollable RowSet is required.

Specify the batch size to use. If left blank, batching insert/update processing is not used (default). This attribute is only applicable when inserting or updating records and may greatly increase the speed of large insert/update operations at the cost of a larger memory footprint.

Specify the action to take when the query produces an empty RowSet. By default, the project will continue with executing the next task. Please note that this attribute does not have any effect for SQL statements that DO NOT produce a RowSet such as insert or update statements.