Error in reading sequential file

prasson_ibm · Post by **prasson_ibm** » Wed Jul 01, 2009 5:11 am

Hi,
I am extracting data from sequetial file and trying to loading into a db2. My job design is like this:-

seq file stage ----->transformer stage------->db2 udb stage

view data is working fine but while running the job gets aborted with fatal error
Sequential_File_0,0: Error reading on import.
Sequential_File_0,0: Consumed more than 100,000 bytes looking for record delimiter; aborting
If anyone has idea,please help me to resolve this problem.

Regards
Prasoon

miwinter · Post by **miwinter** » Wed Jul 01, 2009 5:15 am

How does your data look? What format/delimiter options have you set?

prasson_ibm · Post by **prasson_ibm** » Wed Jul 01, 2009 5:26 am

miwinter wrote:How does your data look? What format/delimiter options have you set?

yes delimiter is correct,thats why i am able to view the data.

miwinter · Post by **miwinter** » Wed Jul 01, 2009 5:30 am

... and the format options you have set?

prasson_ibm · Post by **prasson_ibm** » Wed Jul 01, 2009 5:36 am

miwinter wrote:... and the format options you have set?

Yes......data is in tab delimiter format and i have set it properly in seq src.

chulett · Post by **chulett** » Wed Jul 01, 2009 6:39 am

Record delimiter, not the field delimiter is the issue here. How is that set?

srinivas2705 · Post by **srinivas2705** » Tue Sep 22, 2009 3:30 am

chulett wrote:Record delimiter, not the field delimiter is the issue here. How is that set? ...

Same problem with me.. i have set the Record Delimter as null. Tried as Unix New Lien as well. Does not work!!

chulett · Post by **chulett** » Tue Sep 22, 2009 5:39 am

Start your own thread and provide the relevant details of your problem there, in particular exactly what "does not work!!" means.

DSXchange

Error in reading sequential file

Error in reading sequential file

Sequential File : Error on import