Page 1 of 1
Posted: Fri Jun 03, 2011 4:08 pm
by ray.wurlod
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.
Posted: Fri Jun 03, 2011 4:13 pm
by mandyli
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
Posted: Fri Jun 03, 2011 4:55 pm
by JPalatianos
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
Posted: Fri Jun 03, 2011 5:59 pm
by chulett
... or something (hopefully) more obvious like '0x20'.
Posted: Fri Jun 03, 2011 8:17 pm
by mandyli
Thanks.
I need to use 0x20 or ' ' like this.
Thanks
Man
Posted: Sat Jun 04, 2011 2:29 am
by mandyli
still I am getting same space issue.
Posted: Sat Jun 04, 2011 7:03 am
by chulett
You'll need to be a wee bit more specific than "some space issue" if you need more help.
Posted: Mon Jun 06, 2011 9:42 am
by mandyli
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