AS/400
How can we remove the two years back data from our table? We don't have any time stamp in a table. Please let me know the process to achieve it.
Thanks,
Ravula
Software/Hardware used:
software
Software/Hardware used:
software
ASKED:
March 19, 2013 7:48 AM
UPDATED:
March 19, 2013 1:49 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
no time stamp… what do you have?Is there a date in any format that can be used?Do you have a backup of the file from two years ago?Phil
How do you plan to recognize two-year old data without a time stamp? When you tell us that, then we’ll be able to say how to delete the records. A backup from two years ago would be useful. — Tom
Unless you have a date in the file or a related file that has a date with key fields for you to match on you have quite a problem. What is the need for clearing the old data? If this is to be maintained, why was there not a date field set up in the database? A good rule of thumb in any database design is if the files need to be purged perodically based on your company needs it should contain a timestamp or at least a date field
one trick that help me with a similar data file issue was to find another field that has relevance (assuming no date fields at all). Say you do have a Customer #. So use that to delete records that go with any non-current customer. You end up getting rid of unuseful data without caring when it was created.
Well, you could add a date field to the database, and wait 2 years, then remove 4 years of data.