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 SkipVought 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
0
0
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