data loading from varchar to char field
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 11
- Joined: Wed Feb 25, 2009 11:00 pm
- Location: Bangalore/Hyderabad
data loading from varchar to char field
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.
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.
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am
-
- Participant
- Posts: 11
- Joined: Wed Feb 25, 2009 11:00 pm
- Location: Bangalore/Hyderabad
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom