trim on char in db2 stage querry getting messed up

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
zulfi123786
Premium Member
Premium Member
Posts: 730
Joined: Tue Nov 04, 2008 10:14 am
Location: Bangalore

trim on char in db2 stage querry getting messed up

Post by zulfi123786 »

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?
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

View Data can be misleading. Use some other tool to confirm, something that will display space characers in some way.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”