db2_udb_api and date as SQL type
Posted: Fri Dec 08, 2006 5:25 am
Hi All
I have very simple job: DB2_UDB_API-Copy-DB2_UDB_API. And onest field in DB2 with date type. After copy I checked target table and.... O my god.. All dates copied but it less dates on source table with a day!
I checked came stage in server job and all ok.
Hmm Why my parallel job is wrong? Then I changed SQL type to string and Data element to DATE.TAG on source and target DB2 stage. And my job worked fine...
It`s normal behaviour for DB2_UDB_API?
I have very simple job: DB2_UDB_API-Copy-DB2_UDB_API. And onest field in DB2 with date type. After copy I checked target table and.... O my god.. All dates copied but it less dates on source table with a day!
I checked came stage in server job and all ok.
Hmm Why my parallel job is wrong? Then I changed SQL type to string and Data element to DATE.TAG on source and target DB2 stage. And my job worked fine...
It`s normal behaviour for DB2_UDB_API?