padstring issue while loading into Netezza Database
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 306
- Joined: Wed Jun 21, 2006 11:41 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
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