DSXchange

If this is a specific case and you otherwise want the input pattern to be treated conventionally, use an input text override for MILTON SMITH.

Use an input pattern override.

I can only answer your final question. That answer is No. (That probably addresses the other questions as well.)

No, it's caused by a wrongly-named job (or an uncompiled job) in one of the Job activities. Review the generated Job Control code to see which job it is.

So what you're saying is that the uv -admin -info command was giving the wrong result when DataStage Engine is running? Did you source the dsenv script before running the command?

It doesn't degrade at all, actually. But the statistics are misleading. The downstream link from the Join stage started its clock (the "seconds" part of rows/sec) running as soon as the job started, but didn't actually receive any rows until the sort was complete, at least on one partition...

Uncheck "automatically handle activities that fail" and don't have the Terminator abort the sequence.

This is not my experience.

Do you have multiple versions of DataStage running on this server?

Use Code tags to get the layout right. Then it might be clearer what you're trying to accomplish. Please also advise what the join keys are for each of the Join stages.

Then your Remove Duplicates stage will have its partitioning set to Same which, because the Transformer stage is running using Hash as its partitioning algorithm, will mean that the Remove Duplicates stage will execute using Hash partitioning (the Same as that used in the Transformer stage).

Yes it is possible to create a null in the Modify stage. The function is make_null() as far as I can recall.

Use Tools > Options in Director to set the refresh rate.

The text following "ticket" is different.

I should have thought that to be self-evident.

For anything else you'd better provide some sort of context.

Yes, Oracle libraries in LD_LIBRARY_PATH and Oracle executables directory in PATH. You can't be sure that your jobs execute as dsadm.