Notice the following in this script:
- When using this approach, the DataConnector operator write a single row to the data stream so its input file contains a single record.
- A schema must be defined in order for the input value to be read.
- An SQL host variable (:CustNo) is used in the DELETE statement.
- The colon ( : ) symbol prefixed to CustNo specifies to the database that the value comes from a source external to the SQL DELETE statement.