SQLServer Delete

Use this activity to execute an SQL Delete to delete the record based on the delete statement.

Settings

The Settings tab has the following fields:

Field Description
Connection Name of the Microsoft SQL Server database connection from which to retrieve information. You can select the connection from the drop-down list.

Input Settings

The Input Settings tab has the following fields:

Field Description
Delete A SQL statement used to delete the record from the table. You can construct prepared SQL queries by using substitution variables (or parameters) of the form ?<fieldname> in the delete query statement.
Each substitution variable identifies an input parameter whose mapped value will be substituted into the substitution variable at runtime. You can reuse the substitution variable for the same input parameter elsewhere in the query. The type information for the input parameters used in the WHERE clause, is fetched from the database using the selected connection for the entered delete query. Similarly, input fields on the Input tab of the activity are also automatically generated.
Note: Be sure to include the semicolon (;) at the end of the query. This activity expects a delete query to end with a semicolon to indicate the end of the query. A missing semicolon at the end of the query results in the query hanging.
The following example represents a typical delete query: 
Delete from advisor where i_id=?i_id;
For the above delete query, there will be no output field and input field is generated for i_id (VARCHAR). Also the mapped value for the field name is substituted into the substitution variable ?i_id.
Manually Configure Metadata If you see an error for a valid SQL statement in the Query field, set the Manually Configure Metadata field to True to fetch table metadata manually using simple SELECT statement. For more information, see Manually Configuring Metadata.
Fields The grid is provided for informational purpose only.

Input

This tab displays the input schema of the activity in a tree structure format. The information in the schema varies based on the delete query provided. The fields that were selected on the Input Settings tab will be available in the schema. You can either hard code the values or map them to a field from the output of a preceding activity in the flow using the Mapper.

Output

The Output tab displays the output schema of the activity in a tree structure format. The output is read-only. The output tab rowsAffected field is set to the number of rows deleted by the activity.

Related concepts
Related reference