Deleting Imported Data

This action (dropImported) deletes the imported data between the given dates from the following supported tables:

Note: The tables are imported in Oracle with the same name they are archived with.

If there is no data imported between two specified dates, it returns a notification.

This command uses the following flags:

-action

dropImported

-startDate

<mm/dd/yyyy hh24:mi:ss>

-endDate

<mm/dd/yyyy hh24:mi:ss>

-tableName

<table name>

-connectFile

<filePath>

Note: hh24 is hours represented in 24 hour format. For example, 1:15:00 p.m. is 13:15:00 and 3:00:00 a.m. is 03:00:00.

To run dropImported:

Execute this command as follows:

-action dropImported -startDate <mm/dd/yyyy hh24:mi:ss> -endDate <mm/dd/yyyy hh24:mi:ss> -tableName <table name> -connectFile <filePath>

The following example deletes the imported data between the given dates from the above mentioned tables.

./sdm –action dropImported –startDate 09/25/2007 00:00:00 –endDate 09/26/2007 00:00:00 -tableName Events –connectFile sdm.connect

sdm –action dropImported –startDate 09/25/2007 00:00:00 –endDate 09/26/2007 00:00:00 -tableName Events –connectFile sdm.connect