hello all.
I am using ODBC stage for DB2 on AS/400
There is a column colA of length 2 in the source ..say it has value 'AB'..
there are 104 rows..
when the ODBC loads the data..
it loads 'AB................................." (186 characters) into that column
(i am trying to see the data loaded into the source stage using view data..)
and when I run the job it writes into log :
'string or binay data getting truncated..."
"statement truncated..."
and that row is not being inserted..infact none of the rows are being entered..
any1 faced similar problems ?
Thanks
-Xan
DB2 AS400 - incorrectly loading the data
Moderators: chulett, rschirm, roy
Re: DB2 AS400 - incorrectly loading the data
First thing to try in you get stuck like that is:
1) Try another SQL tool to verify the data you write.
2) Check your field sizes in the stage
3) Replace the target stage by a Sequential file and see whether you still have "expanding" columns (with the same transformations). If you have the problem is probably somewhere in a transformer.
4) Log a case with a Ascential, I haven't see anything similar yet
Ogmios
1) Try another SQL tool to verify the data you write.
2) Check your field sizes in the stage
3) Replace the target stage by a Sequential file and see whether you still have "expanding" columns (with the same transformations). If you have the problem is probably somewhere in a transformer.
4) Log a case with a Ascential, I haven't see anything similar yet
Ogmios