padstring issue while loading into Netezza Database

ray.wurlod · Post by **ray.wurlod** » Fri Jun 03, 2011 4:08 pm

Yes, the name of the environment variable is APT_STRING_PADCHAR, not APT_STRING_PAD. This indicates that any Char data type will be right-padded with 0x0 characters.

mandyli · Post by **mandyli** » Fri Jun 03, 2011 4:13 pm

Thanks Ray,

it is my typo error.
Shall i need to change the APT_STRING_PADCHAR value at job1 and job 2 and job 3 level?

Thanks
Man

JPalatianos · Post by **JPalatianos** » Fri Jun 03, 2011 4:55 pm

The default value for APT_STRING_PADCHAR is low values 0x0. If you want to cahnge this to spaces just delete the 0x0 and replace with a single space in Administrator.

- - John

chulett · Post by **chulett** » Fri Jun 03, 2011 5:59 pm

... or something (hopefully) more obvious like '0x20'.

mandyli · Post by **mandyli** » Fri Jun 03, 2011 8:17 pm

Thanks.

I need to use 0x20 or ' ' like this.

Thanks
Man

mandyli · Post by **mandyli** » Sat Jun 04, 2011 2:29 am

still I am getting same space issue.

chulett · Post by **chulett** » Sat Jun 04, 2011 7:03 am

You'll need to be a wee bit more specific than "some space issue" if you need more help.

mandyli · Post by **mandyli** » Mon Jun 06, 2011 9:42 am

Hi

I have solved this issue.

I have added APT_STRING_PADCHAR value 0x20 into job level for Job 1 and Job 2 and then Job 3 I have used TRIM (column," ", "D") function in Transformer stage.

But still I am not able to understand why this is happening only 8.1 fix pack 2 version. The same job ran fine in 8.1 fix pack 0 versions.

Thanks
Man