I am using an SQL in Cobol 400 to delete around 100 million records out of 200 million records based on a date. What is the best way to delete this much data in one stretch?
The file has key as date.
My sql would look like
Delete from FileA where Date < 'some date'
August 31, 2013 5:14 PM
September 1, 2013 8:45 AM