DSXchange

Routines return a dynamic array and what you're seeing a Field Mark. Use convert() to strip it:

Install whichever compiler the docs say are supported. However, as noted previously, Vista is not supported and likely the cause of your socket errors.

Make sure that LD_LIBRARY_PATH= line is one continuous line, sometimes copy/paste will insert hard returns. One way you can check is with :set list in vi and see where the $ EOL markers are.

You can't "sort" if you need to maintain the original file order. Are your account numbers already sorted properly, all like values contiguous? If so, I'd think the Remove Duplicates stage should do the trick.

kiran_sri wrote:Used a stage variable X and derivation X=X+0

X = X+0? Did you actually mean X+1?

There's more to it than that if you have to give ties equal rank but that should get you closer.

If you still need help after that, post your dsenv.

Have you involved your SysAdmins, the ones responsible for the O/S on those boxes? And please post the complete log entry which shows the command being executed.

Typical situation where dev data does not reveal an issue that production data does. Does it work fine with a 1 node config file?

The C++ compiler only comes into play when you build a job with a transformer in it. What exact version of DataStage is this - 7.5x2? That's the only 7.x version with any hope of working but some fundamental changes were made from Windows 2000 to XP and Vista which I think is where your socket error...

Sure, dscmdexport has always been available.

Of course you can sort and transform in a single job. You'd have to post the actual, unedited error if you wanted us to help with that. Unless, like Ernie is wondering, you're just trying to sort the column names in a Transformer output link to be in descending alpha order. If so, that you'd have to...

Your rank variable would only be incremented when the Marks value changes and ties mean you need to 'skip' ranks. So two values of 46 means the rank goes up by 2 next time rather than 1, so simply keep track of the number of Names per Mark and use that as the increment when the Mark changes. All tha...

Could not what - be read? Does this error persist after a reboot?

There's no 'sorting' possible in a transformer - use a Sort stage for that.

Sort desc by the field you want to rank by then use stage variables for the rank. The trick would be to not increment rank for ties and then keep track of how many ties there were for the next increment.