Purge data from custom table

[superfloyd]

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,

 

[johndanter]

Hi

Just create a UBE over your workfile and it's business view.
You may need an index on the date column in your table, but that depends where you want to delete from maybe.

Select based on your date
Read in each record
Save the key
Delete them using the key
Repeat until it ends

 

[rsvconsulting]

Keep in mind that you may desire to archive that data for historical and comparative reporting purposes.