Connecting Tech Pros Worldwide Forums | Help | Site Map

Urgent - DB2 Function

Newbie
 
Join Date: Oct 2009
Posts: 1
#1: Oct 5 '09
I am writing a script in which I need to put a date function which will automatically generate the first business day of the current month and also the first business day of the last month(i.e Monday). Its a script which will run report every month and I would need that function which would autimatically pull up the business days as mentioned above. Please advise.

SCRIPT:

-- first get list of servers added in the last month
with new_srvrs(physerial, invnum, phyhost, allocxdate) as (
select physerial, invnum, phyhost, allocxdate from inv_old_daily
where allocxdate='2009-08-03'
and INVNUM>(select max(INVNUM) from inv_old_daily where allocxdate='2009-07-01'))

Reply