Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: lifzgud on 24 May 2010 08:41:55 AM

Title: Housekeep records in Data Manager
Post by: lifzgud on 24 May 2010 08:41:55 AM
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.
Title: Re: Housekeep records in Data Manager
Post by: MFGF on 26 May 2010 10:10:05 AM
Just code a SQL node in a jobstream to remove the unwanted rows.

MF.
Title: Re: Housekeep records in Data Manager
Post by: lifzgud on 28 May 2010 04:27:55 AM
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
Title: Re: Housekeep records in Data Manager
Post by: lifzgud on 01 Jun 2010 09:59:01 AM
Thanks:) i was able to do it
Text only | Text with Images