Hi,
I have a varchar field of length 2000 and i am hardcoding the value as 'not valid' in the transformer. Now, when i am loading to the table using Loading method as "LOAD", it is behaving as char i.e it is taking the length as 2000, but when i am loading using UPSERT menthod, its going fine.
The job is quite simple
oracle EE ==> transformer ==> oracle EE tgt
Can any one explain me, how this is happening??
Thanks in advance
varchar is not trimming spaces while loadding to oracle EE
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Nor should it.
will preserve the trailing spaces, because they are part of the data. DataStage behaves in the same way. If you want them trimmed, you have to trim them.
Code: Select all
INSERT INTO table(col1,col2) VALUES (123, "XYZ ");
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.
Ray,ray.wurlod wrote:Nor should it.will preserve the trailing spaces, because they are part of the data. DataStage b ...Code: Select all
INSERT INTO table(col1,col2) VALUES (123, "XYZ ");
I am hardcoding it as "not validate" in the transformer.!! when i load using upsert method, then it is loading as not validate to the target where the length is 12 but when i use the load method it is loading as not validate followed with 1988 spaces. i checked the length of the vlaue ... all rows are returned as 2000
is this problem with sql loader or datastage ?? kindly help me.!!
-
- Participant
- Posts: 7
- Joined: Thu Nov 17, 2005 7:22 am