data loading from varchar to char field

rahulverma · Post by **rahulverma** » Tue Aug 31, 2010 4:37 am

Hi,

I have a column of datatype CHAR(20).
When the DataStage job loads data of length 15 into it, it pads the
remaining 5 spaces with unprintable characters (these are represented by squares in aqua data studio).
This is happening with all CHAR datatype fields at DB2 Target.
Is there any global setting which is causing this? Any other ideas?

Thanks in advance.

srinivas.g · Post by **srinivas.g** » Tue Aug 31, 2010 4:53 am

Use varchar.....

rahulverma · Post by **rahulverma** » Tue Aug 31, 2010 5:00 am

Changing target datatype to VARCHAR solves the problem.
Is there any Other way out to resolve this issue without changing target metadat? I am looking for the resolution without changing the target metadata.
Please suggest.

srinivas.g · Post by **srinivas.g** » Tue Aug 31, 2010 5:20 am

use this option in Transformer stage :Column name[1,15]

srinivas.g · Post by **srinivas.g** » Tue Aug 31, 2010 5:36 am

Ignore previous post. Use below command
use this option in Transformer stage :Column name[1,len(columnname)]

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Aug 31, 2010 6:12 am

srinivas.g wrote:Ignore previous post. Use below command
use this option in Transformer stage :Column name[1,len(columnname)]

Isn't it same as saying just 'columnName' !?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Aug 31, 2010 6:14 am

Search for APT_PADCHAR.

chulett · Post by **chulett** » Tue Aug 31, 2010 6:14 am

$APT_STRING_PADCHAR controls that and the default is a hex zero. Change it to a hex 20 to pad with spaces.

Mandy23 · Post by **Mandy23** » Thu Dec 08, 2011 12:12 pm

srinivas.g wrote:Ignore previous post. Use below command
use this option in Transformer stage :Column name[1,len(columnname)]

Thanks Srinivas.
This helped to solve my problem.

Thanks,
Mandy