storing apostrophe(')
Posted: Tue Apr 01, 2008 7:05 am
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.
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.