DSXchange

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

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

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.

... and the format options you have set?

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.

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

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!!

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