LeonelSanchezJr
Programmer
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)
Thanks,
Leo ;-)
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 ;-)