trim on char in db2 stage querry getting messed up
Posted: Thu Jan 15, 2009 8:28 am
Hi,
I have a column of type Char(3) in a db2 table, its having only one alphabet and rest spaces, i am triming the field in the db2 select querry and putting it in a field defined as char(3). i can see that there are no spaces appended to it by selecting view data option. The problem is that all the records are failing in the join stage. padchar is set to 0x20.
why is it not padding the spaces in db2 stage?
I have a column of type Char(3) in a db2 table, its having only one alphabet and rest spaces, i am triming the field in the db2 select querry and putting it in a field defined as char(3). i can see that there are no spaces appended to it by selecting view data option. The problem is that all the records are failing in the join stage. padchar is set to 0x20.
why is it not padding the spaces in db2 stage?