DB2 Migration
Posted: Mon May 30, 2011 10:07 am
Hi,
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.
Suppose when we read it as VARCHAR then it is good.
Any one come across this kind of issues.
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.
Code: Select all
Job design:
DB2 API Stage --> Transfomer --> Sequential File.
Any one come across this kind of issues.