Housekeep records in Data Manager

[lifzgud]

Hi ,
I wanted to know if there is any way to housekeep records in data manager.
I want to keep only latest one month data in my table and delete the rest.

[MFGF]

Just code a SQL node in a jobstream to remove the unwanted rows.

MF.

[lifzgud]

Hi MF,
When i write a delete query it throws an error saying that
1. ERROR
DS-DBMS-E380: Invalid SQL statement for data selection

[lifzgud]

Thanks:) i was able to do it