Remove back data from AS/400 table

700 pts.
Tags:
AS/400
AS/400 tables
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. 

Software/Hardware used:
software

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • philpl1jb
    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
    51,355 pointsBadges:
    report
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • ToddN2000
    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
    15,605 pointsBadges:
    report
  • aceofdelts
    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.
    1,985 pointsBadges:
    report
  • Yorkshireman
    Well, you could add a date field to the database, and wait 2 years, then remove 4 years of data.    
    5,580 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following