end of character

ann · Post by **ann** » Tue May 30, 2006 3:37 pm

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.

chulett · Post by **chulett** » Tue May 30, 2006 3:40 pm

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.

chulett · Post by **chulett** » Wed May 31, 2006 9:39 am

Code: Select all

Convert(field,CHAR(10)," ")

ann · Post by **ann** » Wed May 31, 2006 11:15 am

Hi chulett,
The convert function work excelent after i used char(10) .
Thank you,
ann