Unusual scenario in datastage

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
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

Soumya, it may be a bug in View Data. In View Data of a Data Set on a single trimmed spaces varchar column, it does appear that one space is in there. If you read the data from the data set, then it actually comes out as an empty string, which is how it was stored. So, I think it must be a bug while viewing data on a single column. I also do not see this issue with more than one column, just like you said.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Top
soumya5891
Participant
Posts: 152
Joined: Mon Mar 07, 2011 6:16 am

Post by soumya5891 »

Thanks Eric.
I have load the dataset into a DB2 table. But it has loaded as space not as empty.I think it is one kind of issue with dataatsge
Soumya
Top
Post Reply

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