Connect SQL form – Completing the Delete tab
As a best practice, include only one SQL statement on this tab. If your situation requires multiple statements, place one statement each in separate Connect SQL rules. Your activity can cause the statements to be executed in the desired sequence. If your situation requires many statements executed in sequence, consider using a stored procedure.
|Delete SQL|| Follow the guidelines in Data Mapping in
SQL. Enter an SQL statement directly into the text box. You can use a
|Error Handler Flow|| Optional. Identify a flow rule that is to be started when this connector rule
is started by a flow rule but fails when the Integrator shape throws a
|Test Connectivity||After you save this rule, you can click to confirm connectivity to the database. No database operations are performed.|