DSXchange

So your job also features a Switch stage with 18 links?

If not, you're hijacking this thread, which we frown upon.

Please begin a new thread, with a meaningful subject.

This will assist future searchers.

So find out, and inform us, what is different between the environment where it does work and the environment where it does not work. "Nothing" is not the correct answer, though the difference may be external to DataStage. Or it may not be. You have to be the detective.

Merge consumes one key from the Update input. Merge is documented as requiring de-duplicated Update inputs if there is more than one.

Lookup can return multiple rows, but has to be set to allow this. By default Lookup returns one row, and generates a warning if more than one is found.

It returns 1, since 45e45 is numeric (provided EXACTNUMERIC is sufficiently large).

You don't even need a routine. Use EVAL in a query.

No, because there is no such thing as a reject from a join. Just as in SQL you get the result of the join. Sure this may not include all rows from the inputs, depending on the rules of the join, but there are never any rejects per se.

Code tags, not Quote tags!

The Reporting Assistant was deprecated at (after) version 5.2, before stage variables existed in DataStage. Therefore I am not surprised that it can not handle stage variables.

The idea was to push people into using MetaStage for their metadata reporting requirements.

There is no solution to this.

Variable JobName is not assigned anywhere.

You are probably getting "variable not assigned, zero-length string used" errors logged, and it's always trying to get information about the job whose name is "" (and which does not exist).

This potentially is bad news. Do you have an export/backup of your project?

To verify whether DS_JOBOBJECTS is indeed corrupted, run the following command, from the Administrator client Command window. Post the results.

You can't. Only the Moderator can.

DataStage does whatever you program it to do (like all computer programs). However you have given us no idea at all what that is. Until you do, there is no way we can help. Also, can you be more precise about "the" DataStage job? Does your script invoke this once per file created by csplit...

How about you Search DSXchange for "User status"? It's been discussed many times before, with full explanations.

Wrap your code in Code tags so indenting is preserved. It's too hard to analyze otherwise.

Where is the ErrorExit label?