Sequential Stage in PX

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
seethamsetty
Participant
Posts: 24
Joined: Sun Nov 13, 2005 6:14 pm

Sequential Stage in PX

Post by seethamsetty »

Yes I am able proceed and need to check with accuracy of data.

Hello,

I am trying to read a xml file in sequential stage PX with two columns (Filename and Record).It is not able to read/

It gives the following error.

Sequential_File_0,0: Consumed more than 100,000 bytes looking for record delimiter; aborting

Record Delimiter = end
Field Delimiter =comma
Field quote = double
I have given the above in the format tab.

Any one has come across this problem

Thanks
seethamsetty
seethamsetty
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

There have been a few folks that encountered this problem. Search on the error message.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Is your XML file really comma delimited? That's very unusual. The stage gave up after not finding a comma (or maybe line terminator) in the first 100KB. I would, too.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply