SQLServer Delete
Use this activity to execute an SQL Delete to delete the record based on the delete statement.
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 is substituted into the substitution variable at runtime. Input and Output tabs are populated based on the query. End the query with semicolon (;) to fetch the metadata in the table at the bottom of the query. 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 | Set the Manually Configure Metadata field to True to fetch table metadata manually. 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 are selected on the Input Settings tab are 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.