DSXchange

Of course not. When the job finishes its shell closes.

There is not.

Further, there are two possible solutions. One is the dependent objects in the design, the other is what was actually run (the logic and/or restart of the job sequence may exclude certain activities).

Yes it's possible, but how you do it depends on how you created it in the first place. If it was created in the account, then the command - which can be executed through the Administrator client Command window - is CNAME. CNAME oldname TO newname If the hashed file was created in a directory and the...

You ought to ask the question - a specific question please - about NULL handling in a different thread. We stick to "one thread, one question" to make it easier on future searchers. Executing a UNIX script one time is done from a before-job or after-job subroutine, typically ExecSH or one of its der...

DataStage has run on HP-UX since day one. And, yes, it remains a supported platform. Make sure that you become aware of version dependencies (which will depend on what version of DataStage you are planning to be on on the new system).

Who knows? It's not really clear what you are trying to do. Have you, in fact, tried it?

Gosh! Is it?!!

It's not a supported platform.

Beat me to it! The typical solution to the many-to-many dilemma is to perform single-file (Unduplicate) match on at least one of the files, and work with the master from each set (remembering that every residual is its own set).

NullToValue is not a UNIX script.

Can you be more precise about your requirement? In particular do you wish to invoke the UNIX command once per run or once per row?

One should have done it.

Do get yourself a premium membership. I discuss this fully in my earlier posts.

Very easy. Use a job sequence with a StartLoop activity to generate the twelve values.

That's why I specified "for example".

You must investigate the job score to find out what is actually being executed. It is rarely exactly the same as what you designed.

Explore the Aggregator stage's null handling properties. Is this column a grouping column or a column for calculation?

Welcome aboard.

That's not the same as changing a parameter value within a job once that job is running.

Please maintain a professional standard of written English at DSXchange. It helps those whose first language is not English, for whom it's difficult enough to understand the standard form!