Specifying the order to Group by in AGG

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
gateleys
Premium Member
Premium Member
Posts: 992
Joined: Mon Aug 08, 2005 5:08 pm
Location: USA

Specifying the order to Group by in AGG

Post by gateleys »

How do we specify the order to Group by in Aggregator stage? For eg., with user specified query, we can have GROUP BY emp.id, emp.sal which groups the records in that order. How is the same done in Aggregator?
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

By entering the columns in that order.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”