Incent Delete Orders

Summary

The incent delete orders command deletes data from Incent.

Syntax

incent delete orders [staged | processed] (BatchNames=<list_of_batch_names_to_delete>)

Parameters

Parameter	Description
[staged \| processed]	Specifies whether to delete staged or processed orders.
BatchNames=<list_of_batch_names_to_delete>	The list of batch names to delete.

Details

The incent delete command deletes the set of staged or processed orders for the specified set of batch names or period names

Examples

// Specifies the batch names as constants
incent delete orders staged BatchNames=List('FEB_2015_DELTA_Nu_2', 'FEB_2015_DELTA_Nu_3', 'FEB_2015_DELTA_Nu_4');
incent delete orders processed BatchNames=List('FEB_2015_DELTA_Nu_2', 'FEB_2015_DELTA_Nu_3', 'FEB_2015_DELTA_Nu_4');
// Specifies the batch names as the result of a select statement
incent delete orders staged BatchNames=(select batch_name from staging.order_item);
incent delete orders processed BatchNames=(select batch_name from staging.order_item);

Related Commands

INCENT PURGE ORDERS