Page 1 of 1

Sequencial file error

Posted: Fri Aug 21, 2009 8:25 am
by arnie_nits
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

Posted: Fri Aug 21, 2009 8:27 am
by ArndW
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.

Posted: Fri Aug 21, 2009 8:28 am
by chulett
Does "read data into" mean you are writing to a file? Or simply trying to read it? :?

Posted: Fri Aug 21, 2009 8:51 am
by arnie_nits
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.

Posted: Fri Aug 21, 2009 8:58 am
by miwinter
Parallel job sequential file stages are much more "fussy" about datatype and format than server jobs, as you've just experienced :)