DSXchange

Use an after-job subroutine to test the interim status of the job and to write your file based on that condition. If DSGetJobInfo(DSJ.ME, DSJ.JOBINTERIMSTATUS) = DSJS.RUNOK Then Call DSExecute("UNIX", "echo " : DSJobName : " is success. > filepath", Output, ...

In a Before Job subroutine echo the desired line into the file.
In the Sequential File stage, append to the file.

I suspect that it's none of those, but that you don't have any IS user that is properly credentialled to use DataStage.

In the IS Admin web console, choose Domain Management, then DataStage credentials. At the very least set up a default DataStage user ID.

Deployment on what?

If you need to ask this question then maybe you need a new nick.

a) with my usual professionalism
b) compliance with customer's in-house standards
c) accuracy, auditability, recovery, efficiency

Try pre-processing the file to eliminate the linefeeds that follow "Z" characters, and rely on the definition of "Z" as the record delimiter.

You should also be able to edit the table definition to indicate that the column in question contains line terminator characters (linefeeds).

5MB score is BLOODY HUGE (pardon my language)!

A typical score is only a couple of tens of KB.

Substrings() is slightly less efficient, because it carries within it the ability to deal with multi-valued data. Prefer Left() and Right() functions or the square bracket notation for substringing.

You were relying on something that did not work properly, and has now been fixed. The patch will un-fix it, so that previous behaviour can resume. A better solution would be to get the logic of the job design correct.

The Merge stage performs a join between two text files. I do not know whether entering the temporary directory is mandatory, but attempting to compile without it filled in will answer that question.

I establish a regime of automatic exports using a BAT file on the client. Several others have too - a search of the forum ought to elicit one or two examples. By that means I can always recover individual DataStage components should the need arise.

"Variable not assigned" will not be generated unless you (that is, the code) tries to access that variable. A Transformer with only a single output link does not need to. The cause can only be poor code generation. Examine the code produced by the Transformer stage (in the RT_BPnnn directory) to see...

Please explain how this is a comment about the DSXchange site/forum, and then post your question in the correct forum.

Probably that the REJECTED link variable is not correctly initialized. This - if my diagnosis (based on your description) is correct - is a bug in the product, one about which you can do nothing.

Welcome aboard. Firstly, I would ask why you feel you have to convert server routines to parallel ones. Given the level of expertise apparent in your question, I'd recommend hiring IBM Software Services or a competent consultant. The language for parallel routines is C++. The only way to "convert" i...