DSXchange

DSguru2B wrote:Do the sort in your database stage itself by using order by cluase. Let the aggregator know what keys the incoming data is sorted on.

Do you mean the first Oracle Stage? Do I need to add sort in the Select statement? Does it matter what sort I pick?

Columns were grouped by ODBC stage are different from Agg stage and so I will try to use same columns used in agg stage to group by in ODBC stage. Could you please explain to me where the sort needs to be added? Is it in the Aggregator stage? Or in the Transformer? I haven't used DataStage for a wh...

Hi,

I logged in as administrator and tried to execute UNLOCK INODE command on the locked job. However, I received -- verb "UNLOCK" is not in your VOC error message. Does anyone know what I am doing incorrectly? Thanks for your help.