Stop the job after 1 read row

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
wahil
Participant
Posts: 23
Joined: Tue Oct 25, 2005 11:14 am

Stop the job after 1 read row

Post by wahil »

Hi to all,

I have the job below:

HASH ---> TRANSFORM ---> SEQFILE

This hash have millions of rows, but i need stop the job after read the first only. In transform stage i put @INROWNUM in constraint, but the dstage read all rows in hash...It's take 6hours to finish...
I try with @OUTRONNUM too, but the result as the same.

Any idea?

Thanks a lot!
Last edited by wahil on Wed Aug 23, 2006 12:39 pm, edited 1 time in total.
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

DUPLICATE POST: Please delete this post.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply