Function to calculate the address stop date: -- pseudo code: Create function generate_stop_date count MVPOS for i to MVPOS stop_date = [login to view URL] + 1 day the very last stop date should be today's day - 1 day Usage: select eff_date, generate_stop_date(eff_date, mvpos) from tbl sample data: KEY MVPOS EFF_DATE calc_dt ADDR1 12345678 2 11/1/1999 6/28/2010 12345678 3 3/15/1995 10/31/1999 12345678 4 1/1/1980 3/14/1980
## Deliverables
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).
## Platform
udb2 db2 the coder must be proficient in writing udf db2 functions on unix platform