Convert VarChar to Char

kanasai167 · Post by **kanasai167** » Wed Feb 29, 2012 9:34 pm

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?

kandyshandy · Post by **kandyshandy** » Wed Feb 29, 2012 9:41 pm

search for PADCHAR in this forum..

ray.wurlod · Post by **ray.wurlod** » Wed Feb 29, 2012 10:08 pm

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

kanasai167 · Post by **kanasai167** » Thu Mar 01, 2012 2:01 am

ops , just notice that i post at the wrong section

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

Thanks.