Recently we started migration of database DB2 8.2 to 9.5 version. During testing we found one issue when we read Date field(BIZDATE) as Date at DB2 API Stage then the BIZDATE is 1 day down to the actual date.
Suppose actual date: 2011-02-20 then output is coming as 2011-02-19.
View the data from DB2 stage, check what date it will show. Then you u will come to know that where is the error, check also any warning in the job after running.
Mahantesh Shivanagi
Basel-Developement team
Standard Chartered
There are lot of Transformations applied at transformer stage. Eventhough i removed the transformer to find the issue. But no luck it is behaving same manner.