DSXchange

Check the settings of APT_LINKER_OPTIONS environment variable, or whatever you've overridden it with on the Build tab in the Transformer stage properties. The error message complained about this command: cxx -LD:/Ascential/DataStage/Projects/Awas_test_james/RT_BP14.O/ -LD:/Ascential/DataStage/PXEngi...

There is a global Decimal Output property in the Aggregator stage. As well any calculated column can override that with its own Decimal Output property. Specify precision,scale (that is, the precision value, a comma, and the scale value).

If it can be read with a Sequential File stage it was created with a Sequential File stage, or something at the command (operating system) level. It is not a Data Set, which is a parallel structure.

There is no such thing as a parallel job sequence. There are only four job types in DataStage: server, mainframe, parallel and job sequence.

Therefore the "vice versa" question is really moot.

Now you're getting well into the realm of "outside DataStage" - the Command stage executes a command, not a subroutine. You would need to create a command in code (and therefore be relying on a "support file", albeit one containing the command source code and another containing the compiled command)...

"Last" in the Aggregator means you don't need to do that. :D

Please post the actual record layout, ideally in COBOL FD format. You can process this file with a Sequential File stage; read the entire line as a single VarChar column then use the record identifier (the first six characters) to constrain output links from a Transformer stage. On each output link ...

Pre-load and preserve an image of the parent table in a hashed file. Use this image to prevent referential integrity constraints. Mark every row you load, as Wolfgang suggested or with the job run timestamp, so that they can be undone irrespective of your commit setting.

Look in RT_BP2311/JOB.1396960201.DT.1465440079.TRANS1 and check the code either side of line number 107 to see what might have happened. In particular look for a reference to a subroutine whose name begins with "$".

You can use SQL if you prefer.

DSSetUserStatus is actually a subroutine. To use it from a Transformer stage you need to embed it in a routine of type "transform function". Search the forum to find an example.

Clear Status file is dangerous. That's why it asks "are you sure?" twice.

Please use correct English on DSXchange. The word "wud", whatever it is, is not a past tense or subjunctive form of the verb "to be".

Have you reset the job? (This is done in Director - it is not recompiling. If you have recompiled you have lost the evidence, and will need to re-run the job to reproduce the problem, then reset the job.) After you have reset the job there will probably be an Informational message in the log, with s...

How soon is the interview?

Your Repository may need re-indexing, or you may be running out of memory on the client.