using a sequential file stage as an input for "XML inpu

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

Post Reply
suneyes
Participant
Posts: 82
Joined: Mon Jul 21, 2008 8:42 am

using a sequential file stage as an input for "XML inpu

Post by suneyes »

Hi ,
Can I use a sequential file as an input for XML input stage in a parallel job. If it can be done,please enlighten me.
sun
suneyes
Participant
Posts: 82
Joined: Mon Jul 21, 2008 8:42 am

Post by suneyes »

I have removed all properties in the [Format] tab of sequential file stage and added these two:

Record level:

Record type=implicit

In the Field defaults:

Delimiter=none

I tried putting Final delimiter=end
but any of these things didn't work.
At one place the job got aborted saying that

"one or more fields haved elim=end"

I need entire XML file in a single columnof a single row.
If any one can help me out with this, it would be very helpful for me.
sun
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Better to replace it with an External Source stage and just pass in the filename, let the XML Input stage do the reading of the file itself, directly.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply