Purging data from custom table

superfloyd

Member
Hello,

I have a custom table that is being growing exponentially, we need to create a purge process that will delete data based in date calculations(anything that is less than this x date will be deleted). Anybody could recommend the best approach to take in this regard?

Thank you,
 
You might want to evaluate the properties of standard JDE purge and archiving and apply those rules to your custom table solution and testing.
 
If this is a custom table - I'm presuming its not got a header/detail ?

If it is a single custom table - then you can easily just make a replica of your table as a "history" version of the table, then have a process that copies the data from the original table to the history table and deletes the rows in the original table based on a date range. If its a flat, single table - then you should easily be able to achieve that. And have another application written that restores the data from "history" if needed later on !
 
Back
Top