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
-
- Participant
- Posts: 48
- Joined: Sat Oct 22, 2005 9:56 am