Sort Stage - Clarification

Raftsman · Post by **Raftsman** » Fri Oct 25, 2013 10:48 am

When using a sorted Dataset as input to a join statement, if we don't put a Sort Stage set to "do not sort" and "same", the Join stage insert an internal Tsort even if we set the input partitioning of the Join stage to "same"

In conclusion, in order for Datastage NOT to put an internal Tsort, you must put a Sort Stage prior to the Join stage set to "do not sort" and "same".

Is this correct or is there anther way. It just seems like clutter on the palette.

Could someone please confirm.

Thanks

chulett · Post by **chulett** » Fri Oct 25, 2013 11:11 am

What you call "clutter" I call a useful piece of information.

You can also use an APT variable to turn off automatic TSORT insertion for that entire job but I personally would recommend sticking with the Sort stage.

Raftsman · Post by **Raftsman** » Fri Oct 25, 2013 11:23 am

Don't get me wrong, I just thought that if we could set this in the join stage, less stages would exist on the palette. I agree that it's useful.

Thanks for the answer.

chulett · Post by **chulett** » Fri Oct 25, 2013 12:04 pm

I don't believe there is such an option in the Join stage... but let's see what others have to say. Pretty sure those are your two options.

ray.wurlod · Post by **ray.wurlod** » Fri Oct 25, 2013 2:08 pm

There is no such option in the Join stage.

Raftsman · Post by **Raftsman** » Fri Oct 25, 2013 2:24 pm

Thanks for the info. I will mark this resolved.