Emulate behavior of Sequence funnel

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
rameshrr3
Premium Member
Premium Member
Posts: 609
Joined: Mon May 10, 2004 3:32 am
Location: BRENTWOOD, TN

Emulate behavior of Sequence funnel

Post by rameshrr3 »

Can I emulate behavior of a sequence funnel using a server link collector so that input link data streams are ordered in a predefined sequence- I dont see a sequence or ordered collection algortithm , and sort-merge in link collector has its problems/bugs [darn:]? If not , Is there a way using a hashed file to do this ? The job is doing a lot of complicated logic using server routines and client doesnt have the fund$ approved to convert it to PX yet.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You could use a hashed file. When reading back from the hashed file include a sorting clause (for example BY fieldname or BY.DSND fieldname) in the Selection field.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
rameshrr3
Premium Member
Premium Member
Posts: 609
Joined: Mon May 10, 2004 3:32 am
Location: BRENTWOOD, TN

Post by rameshrr3 »

Thanks Ray . I will make note of that - the need shall soon arise .
Post Reply