Junk characters in char column of DB2 Table
Posted: Wed Mar 25, 2009 10:38 am
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
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