Sequencial file error

arnie_nits · Post by **arnie_nits** » Fri Aug 21, 2009 8:25 am

Hi,

I am unable to read data into a sequential file.
Error: Bad trailing quote character at field "DateDrawn"; looking for '34' but found '0', at offset: 161

DateDrawn is a timestamp field
Not getting any clue of it . Plz Help.

Thanks
Arnie

ArndW · Post by **ArndW** » Fri Aug 21, 2009 8:27 am

Char(34) is the double-quote character, which is expected in position 161 of the line to close off the "DateDrawn" field but which is not present in the data. Open that file in your favorite editor and analyze the line in error. Most likely some field on that line is shorter/longer.

chulett · Post by **chulett** » Fri Aug 21, 2009 8:28 am

Does "read data into" mean you are writing to a file? Or simply trying to read it?

arnie_nits · Post by **arnie_nits** » Fri Aug 21, 2009 8:51 am

Thanks for the reply.

Actually the i/p to the sequencial file is the o/p from a server job sequencial file. And surprisingly I am able to read that with a server seq file and not with aparallel seq file.Really confused!!

Thanks,
Arnie.

miwinter · Post by **miwinter** » Fri Aug 21, 2009 8:58 am

Parallel job sequential file stages are much more "fussy" about datatype and format than server jobs, as you've just experienced