Hi All,
I am trying to derive a column from another column. In target table the derived column is CHAR18.But always its derived value wont exceed 8 character length.So datastage is padding the rest of the length with boxes of junk character.I am using environment variable APT_PADCHAR as 0x0 in job parameter.Tried changing char to varchar through out the job and also tried padchar function.I am working on DB2 database
Still it gives me boxes in target Table data.But in intermediate datasets it is not showing any junk/spaces.
Please help if anybody knows the issue
Thanks
Sree
Junk characters in char column of DB2 Table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3
- Joined: Wed Mar 25, 2009 8:31 am
- Location: India
-
- Participant
- Posts: 3
- Joined: Wed Mar 25, 2009 8:31 am
- Location: India
Re: Junk characters in char column of DB2 Table
Thanks for your reply..Tejastehavele wrote:Try using 0X20[space] instead of 0X0.
I tried this..But still it gives me the same problem...and in our orgzn almost all project the value for apt_string_padchar value is set as 0x0 and not possible to chnage this to single space or 20x0.I can see if I give single space for this APT variable the issue is not happening
Sree
-
- Participant
- Posts: 3
- Joined: Wed Mar 25, 2009 8:31 am
- Location: India