DSXchange

Lose the quotes around Arg1.

Did you select the activity variable from a menu (expression editor) or type it in? The correct activity variable name has the name of the Execute Command activity, then a dot, then $CommandOutput (note the capital "C"). Incidentally, the correct terminology is "job sequence". A Sequencer is a compo...

So this is user-written after-job subroutine, not ExecSH? This is new information. Forgive us for being tricked by your Subject! I always use DSGetParamInfo() to retrieve the value of a job parameter in a user-written routine. Others will tell you that it is not strictly necessary; I find that it gi...

It means that NLS_LANG, the environment variable that Oracle uses for character map recognition, has not been set.

All warnings are OK in the sense that DataStage software has been coded so as to generate them. You can prevent them (in this case by setting the PWD environment variable) or you can demote/suppress them. Never neglect them. Some are bad things, some simply report "unusual" (do not occur every run) ...

Status 2 (finished with warnings) will not affect the batch/job control/job sequence. Please answer the questions about the status of the jobs as reported in Director. I find that my statement of belief about the BASIC Transformer is perfectly clear. I have intentionally not given the reasons behind...

Normalized data are extracted using UNNEST (examine the SQL) and therefore contain no value marks.
However, because all rows for any particular @ID come out together (necessarily), you could use a simple stage variable to carry the counter. Detect when @ID changes to reset to 1.

There seems to be a current thread on this in the SOA Edition forum.

Try it. Let us know.

And your reason for this? It's like arguing that you will only use Transformer stages in your jobs because all your other jobs use Transformer stages. If you insist on using parallel job either make absolutely sure that the data are correctly partitioned and sorted and/or execute in sequential mode.

Search!

What are the status values as reported in Director?

Beware of anything reported from the BASIC Transformer stage; I am not totally convinced that its interface to the job monitor is totally accurate.

The Palette is only a developer's aid. It is fully customizable. You can put whatever you like wherever you like.

When you reset the job, does its status change to "has been reset"?

Anyone looked at the score, rather than the generated OSH?

In particular, you need to manage the single-quote characters, required in the context of the IN clause, when passing from a job parameter.