DSXchange

Im trying to convert Varchar to Char , same length.
I just change the data type at the target db2 connector.
After the job run , when view the data , those value length less than its field length , the spaces is filled with '?'.

For example ,
My source value in db2 , length = 10
'123 '
'qwe '

Output value in db2 , length = 10
'123???????'
'qwe???????'

Any way to solve this issue?

search for PADCHAR in this forum..

Actually, APT_STRING_PADCHAR does not apply to server jobs. This forum is for server jobs.

ops , just notice that i post at the wrong section

i change the APT_STRING_PADCHAR to '0x20' and the weird character gone.

Thanks.