sorting on multiple columns

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
narsingrp
Premium Member
Premium Member
Posts: 37
Joined: Wed Jan 21, 2004 10:38 pm

sorting on multiple columns

Post by narsingrp »

I am trying to sort the records based on eleven columns in order .In my case some of the columns in sort sequence are nullable .
How the data will be sorted if we get nulls in these columns.Do nulls takes precedence.Any help is appreciated


Thanks
Narsing.
gh_amitava
Participant
Posts: 75
Joined: Tue May 13, 2003 4:14 am
Location: California
Contact:

Post by gh_amitava »

Hi,

DataStage takes care about Null automatically in Sort stage.

Regards
Amitava
narsingrp
Premium Member
Premium Member
Posts: 37
Joined: Wed Jan 21, 2004 10:38 pm

Post by narsingrp »

Thanks .Do Nulls takes precedence in sorting?



Narsing
Post Reply