Hi,
The source data is like this M'Sateesh and the column is of varchar2(9) in both source and target but when i am trying to load the data it says "value too large for column actual: 10, maximum: 9 eventhough it is coming 9 from input.
When i tried to insert this value in database using statement by embed single quote M''Sateesh , it was inserted properly where in when i tried to load it using datastage it is throwing same error.
I used the following function in datastage
Convert("'","''",MyString)
Could you please let me know your inputs.
storing apostrophe(')
Moderators: chulett, rschirm, roy
Output 2 new columns to test - Len(In.Col) and Len(Trim(In.Col)). Both should be equal and 9 for "M'Sateesh"
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 48
- Joined: Sat Oct 22, 2005 9:56 am