Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to Update and/or Insert Recs In Report Caster Library Access List

Status
Not open for further replies.

LeonelSanchezJr

Programmer
Jan 26, 2001
522
US
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 ;-)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top