Need to Update and/or Insert Recs In Report Caster Library Access List
Need to Update and/or Insert Recs In Report Caster Library Access List
(OP)
We're on WebFOCUS version 7.1
The backend is DB2 (which I'm not familiar with since my previous job had SQL Server backend).
We have a Library Access List which needs to be updated daily.
The 2 current BURST VALUES are as such:
2007/07/04: My Report (999-99999)
2007/07/04: Your Report (999-99999)
What I need to do is insert 2 new records each day with
the new date as such:
2007/07/05: My Report (999-99999)
2007/07/05: Your Report (999-99999)
Then, I need to delete the 2 oldest records for the previous year:
2006/07/04: My Report (999-99999)
2006/07/04: Your Report (999-99999)
Last but not least, I need to physically delete the 2 reports from the library.
2006/07/04: My Report (999-99999)
2006/07/04: Your Report (999-99999)
The backend is DB2 (which I'm not familiar with since my previous job had SQL Server backend).
We have a Library Access List which needs to be updated daily.
The 2 current BURST VALUES are as such:
2007/07/04: My Report (999-99999)
2007/07/04: Your Report (999-99999)
What I need to do is insert 2 new records each day with
the new date as such:
2007/07/05: My Report (999-99999)
2007/07/05: Your Report (999-99999)
Then, I need to delete the 2 oldest records for the previous year:
2006/07/04: My Report (999-99999)
2006/07/04: Your Report (999-99999)
Last but not least, I need to physically delete the 2 reports from the library.
2006/07/04: My Report (999-99999)
2006/07/04: Your Report (999-99999)
Thanks,
Leo