Extract Tool

Cancel Extract Selection Option (8 of 9)

You can cancel an extract activity any time before the entries are purged by using the Cancel Extract Selection option. If the extract activity status is UPDATED DESTINATION FILE -- meaning the entries have already been moved to the destination file -- you'll see a warning notice. At this point, you can roll back or delete the new entries that were created while using the Update Destination File option.

After you have canceled an extract activity, VA FileMan deletes the ARCHIVAL ACTIVITY file reference to the extract activity. In addition, you will once again be able to gain access to all of those source entries that VA FileMan locked during the update of your destination file. If you wish to extract data without purging the source entries, cancel the extract activity to unlock the selected entries in the source file. You will encounter the following dialogue while canceling an extract activity:

Select EXTRACT OPTION: CANCEL EXTRACT SELECTION
Select EXTRACT ACTIVITY: CHANGE  3 CHANGE 08-31-92 
  UPDATED DESTINATION FILE      SELECTOR:SMITH,J EXTRACT

Are you sure you want to CANCEL this EXTRACT ACTIVITY? NO// ??
    Enter YES to stop this activity and start again from the beginning.

Are you sure you want to CANCEL this EXTRACT ACTIVITY?  NO// YES

This extract activity has already updated the destination file.

Delete the destination file entries created by this extract activity? NO// ??

     Enter YES to rollback the destination file to its state before 
the update.

Delete the destination file entries created by this extract 
activity? NO// 

>>> DONE <<<

If you wish to cancel an extract selection so that you can start over, enter YES at the "Delete the destination file entries..." prompt. Entering YES prevents you from sending a duplicate set of entries to the destination file. If, on the other hand, you simply want to cancel the extract selection, pressing the Enter/Return key at the prompt unlocks the source entries and retains the destination file entries.

Reviewed/Updated: March 4, 2007