Warnings in DB2 to Oracle Enterprise Migration
Posted: Fri Sep 26, 2014 12:15 am
There is an Old job in my project where a simple DB2 to Oracle migration is going on with out any transformation. Db2 and Oracle Enterprise Stage is used, not the connectors. I am running the job in DS8.7 now. The Source Table data looks like this,
Column_Name Size
COLUMN1 10
COLUMN2 20
COLUMN3 4
When I run the Job, I am getting warnings in DB2 stage that,
'The Size specified to the column COLUMN3(4) is less than that of source table column (20); Data Truncation may result'
This is happening in many similar type Jobs, the length of COLUMN3 is campared with length of COLUMN2... The Order in which I wrote the Custom SQL, the order in which I added columns and the order in which the columns are present in table is same. There are similar posts in the forum but none have comeup with a solution. Please help.
Column_Name Size
COLUMN1 10
COLUMN2 20
COLUMN3 4
When I run the Job, I am getting warnings in DB2 stage that,
'The Size specified to the column COLUMN3(4) is less than that of source table column (20); Data Truncation may result'
This is happening in many similar type Jobs, the length of COLUMN3 is campared with length of COLUMN2... The Order in which I wrote the Custom SQL, the order in which I added columns and the order in which the columns are present in table is same. There are similar posts in the forum but none have comeup with a solution. Please help.