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
Conversion on a field
Moderators: chulett, rschirm, roy
Is the sequential file comma delimited and do the strings have a valid quote character? If yes, then DS can read it correctly. You will have to specify in the column definition of the source file "column contains delimiters".
Good File format: 1,2,"Hello, Goodbye",4,5
Unusable File format: 1,2,Hello, Goodbye,4,5
Good File format: 1,2,"Hello, Goodbye",4,5
Unusable File format: 1,2,Hello, Goodbye,4,5
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>