Harryhome, when you execute a SELECT sql in DB2 for that column, do you get "ABC " or "ABC"?
Based on your answer, we can first find whether it is from DB2 or DS. If you have defined the column as CHAR(4) in source and target datasets (in DataStage), no function will help you to remove trailing WHITESPACE.
Also, check PADCHAR environment variable..
remove null values appended to data
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore