Special Character NEL as a character in a column
Posted: Thu May 05, 2016 9:33 am
Hi
My job reads data form a DB2 table and writes to Oracle table. A column in my DB2 table is of character type and NEL (special char) is one of he character in the string for few rows, because of this character the string breaks in to two line and I can write this to my oracle table. Hence my job is failing
How can I remove this special character forn the string and make that string into one line.
I tried with COnvert(Char(10),' ',abc.xyz), COnvert('\n',' ',abc.xyz) but nothing is happening. I am doing this in a PX transformer
Please Suggest
Regards
Manoj
My job reads data form a DB2 table and writes to Oracle table. A column in my DB2 table is of character type and NEL (special char) is one of he character in the string for few rows, because of this character the string breaks in to two line and I can write this to my oracle table. Hence my job is failing
How can I remove this special character forn the string and make that string into one line.
I tried with COnvert(Char(10),' ',abc.xyz), COnvert('\n',' ',abc.xyz) but nothing is happening. I am doing this in a PX transformer
Please Suggest
Regards
Manoj