Hi all,
I have an as400 table to extract, which has comments field. The length is 255 char field. And has ' ' character in it. Which is recognized as carriage return for datastage. And when I run job it recognizes as next record.
Example data is:
|"11111"|"emailid"|"comments data here starts the problem."|"2006-06-05"||"22222"|"emailid"|"comments data"|"2006-06-05"|
When I try to view the data it gives the following error.
job..Seq_out_Link_2: read_delimited() - invalid quotes, row 3234 column COMMENTS= "COMMENTS DATA"
when i say ok and try to look at the data . The comments col value goes to next record.
Any suggestions would be help full.
end of character
Moderators: chulett, rschirm, roy
The Sequential File stage has a 'Contains Terminators' option on the Columns tab that you'll need to scroll over to see. Setting it to 'Yes' for the columns where the terminator character is in the data will allow the stage to read the file correctly.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Code: Select all
Convert(field,CHAR(10)," ")
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers