Can anybody help me fix this warning.

Minhajuddin · Post by **Minhajuddin** » Mon May 21, 2007 6:48 am

Hi all,

Can anybody help me fix this warning.
I have a source file(sequential), a transformer, and a target sequential file
The delimiter in these files is '|' and I these are DOS files. I even set the Record Delimiter String as 'DOS FORMAT"

Sequential_File_0,0: Field "SUMMARY_BILL_DATE" delimiter not seen, at offset: 184

Thank you.

keshav0307 · Post by **keshav0307** » Mon May 21, 2007 6:56 am

is SUMMARY_BILL_DATE the last field,
May be the final delimiter not defined correctly

HanuKoya · Post by **HanuKoya** » Mon May 21, 2007 9:45 am

You have to check your source data. I guess your source data doesn't have delemiter "|"

ray.wurlod · Post by **ray.wurlod** » Mon May 21, 2007 3:28 pm

Check (don't assert) that the delimiter in the file is "|" and that the delimiter character specified in the Format properties is also "|". Whatever the delimiter character is in the file, make it the same in the Format properties.

rafik2k · Post by **rafik2k** » Tue May 22, 2007 1:29 am

Can you post some sample data?

Minhajuddin · Post by **Minhajuddin** » Tue May 22, 2007 9:48 pm

Hi all,

Thanks for all your help!
It has been fixed.
I am highly indebted to this site. :D

ray.wurlod · Post by **ray.wurlod** » Tue May 22, 2007 9:58 pm

Help future searchers. Explain HOW it was fixed.

Minhajuddin · Post by **Minhajuddin** » Wed May 23, 2007 1:03 am

Hi Ray,

Actually the error was that some of the columns were 'CHAR' datatypes instead of 'VARCHAR'.
And When I changed it to VARCHAR it got fixed.

:D:D:D:D:D

DSXchange

Can anybody help me fix this warning.

Can anybody help me fix this warning.

Re: Can anybody help me fix this warning.