Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
prasson_ibm
Premium Member
Posts: 536 Joined: Thu Oct 11, 2007 1:48 am
Location: Bangalore
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
Participant
Posts: 396 Joined: Thu Jun 22, 2006 7:00 am
Location: England, UK
Post
by miwinter » Wed Jul 01, 2009 5:15 am
How does your data look? What format/delimiter options have you set?
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
prasson_ibm
Premium Member
Posts: 536 Joined: Thu Oct 11, 2007 1:48 am
Location: Bangalore
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
Participant
Posts: 396 Joined: Thu Jun 22, 2006 7:00 am
Location: England, UK
Post
by miwinter » Wed Jul 01, 2009 5:30 am
... and the format options you have set?
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
prasson_ibm
Premium Member
Posts: 536 Joined: Thu Oct 11, 2007 1:48 am
Location: Bangalore
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
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Jul 01, 2009 6:39 am
Record delimiter, not the field delimiter is the issue here. How is that set?
-craig
"You can never have too many knives" -- Logan Nine Fingers
srinivas2705
Participant
Posts: 3 Joined: Wed Sep 17, 2008 10:02 am
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!!
Regards,
Srinivas Jalasuthram
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers