Write 1 record in sequential file

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
suja.somu
Participant
Posts: 79
Joined: Thu Feb 07, 2013 10:51 pm

Write 1 record in sequential file

Post by suja.somu »

Is it possible to write 1 record in a sequential file ? I want to run the job in 4 node config

I am reading 10 records from Database and want only 1 record in a file. I used the Filter option ( head -1) in sequential file stage. The job aborted with error.

Export failed, write() failed. Broken Pipe.

What is the issue? Can someone help me to fix the issue or give an alternate solution to this problem?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Use a Head stage rather than a filter command. The Sequential File stage executes in sequential mode on a single node, so the number of nodes in your configuration file does not really matter.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

Call the plumber.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Post Reply