Conversion on a field
Posted: Wed Mar 22, 2006 9:43 am
All,
I have the following job
DB2 Stage ------> Transformer -----> Sequential File
The sequential file is comma delimited. However I have a field which is of type longVarChar and had commas inside the data. I had been getting the "too many columns in a row error" which I could fix by specifying the quote character as "
The sequential file has to be now subjected to cleansing wherein I will have to set the quote character to 000 and the previous error will spring back. Could anyone help me out with this?
-- Bob
I have the following job
DB2 Stage ------> Transformer -----> Sequential File
The sequential file is comma delimited. However I have a field which is of type longVarChar and had commas inside the data. I had been getting the "too many columns in a row error" which I could fix by specifying the quote character as "
The sequential file has to be now subjected to cleansing wherein I will have to set the quote character to 000 and the previous error will spring back. Could anyone help me out with this?
-- Bob