Code: Select all
select
BUSINESS_DATE
from saggbp2.etl_business_time
where BUSINESS_DATE in (#BD#)
Eg:- (2008-11-26,2008-11-28,2006-01-01).
But it did not work in DB2 stage. The Job aborted.
I tried coverting the source Date in to string by using VARCHAR() function and using the following query
Code: Select all
select
BUSINESS_DATE
from saggbp2.etl_business_time
where VARCHAR(BUSINESS_DATE) in ('#BD#')
Is there any way around to make this work in DB2 stage itself?
Thanks