Delete Block

Use a Delete Block to delete records from the specified datastore. When configuring a Delete Block you need to:

Block Properties — General Tab

From the Block Properties General Tab, you can change the Block Label, add a description, set batch processing options, and select the entity to use for this operation.

Set Batch Processing Options

Note: Error handling options configured on the Error Handling tab are disabled if Batch Processing is enabled on the Block Properties General tab. When Batch Processing is enabled, the following text is displayed on the Error Handling tab:

Batch processing is enabled, records with errors are processed by subsequent Blocks.

If your Connection supports batch, or bulk, processing, the Batch Processing option is available.

Note: For Salesforce Connections, see TIBCO Scribe® Online Connector For Salesforce for additional information.

  1. Select the Process This Operation In Batches Of checkbox.
  2. Select the size of the batch; from 1 to 10,000.

    When the Solution runs, the source records are stored and then processed in batches of the specified number of records for this Block.

Block Properties — Matching Criteria Tab

Use the Block Properties Matching Criteria Tab to specify one or more fields in your source and target data to use for selecting records to delete.

Block Properties — Error Handling Tab

Note: Error handling options configured on the Error Handling tab are disabled if Batch Processing is enabled on the Block Properties General tab. When Batch Processing is enabled, the following text is displayed on the Error Handling tab:

Batch processing is enabled, records with errors are processed by subsequent Blocks.

Use the Error Handling options to enable or disable processing this record when a Block operation encounters a problem. For the Delete Block, errors can be logged as follows:

See Block Properties Error Handling Tab for additional information.

Block Properties — Errors And Warnings Tab

If there are any errors or warnings for this Block, the Errors and Warnings tab displays the number of errors or warnings in the tab name. See Block And Map Errors And Warnings.

Once you have corrected the errors, select the Validate button to update the Errors and Warnings tab.

Related Topics

Working With Blocks

Mapping Blocks

Viewing Execution History

Block Properties Matching Criteria Tab

Batch Processing

Block Properties Error Handling Tab