DSXchange

On UNIX platforms there is no ".exe" suffix. The dsjob executable is to be found in the DataStage engine's bin directory. Your command search list (the PATH environment variable) apparently does not include this directory.

Or simply a Routine activity (sleep until 07:30) with an unconditional link to a Terminator, these in the same job sequence as everything else.

The Terminator can send Stop requests to every activity currently running under control of the job sequence in which it occurs.

There is no certification for server edition (as you have marked your job type). There is, however, certification for enterprise edition (the forum in which you posted your question).

What version of Oracle client is installed on your DataStage server machine?

It might be worth checking whether anything else was changed. I suggest strongly that you track down this contractor - other sites may be being damaged through his/her ignorance. The report from $DSHOME/bin/analyze.shm -t will put an asterisk beside any uvconfig parameter that is not set to its defa...

Still waiting to see the exact error message posted...

Do you have a full specification of the logic written out, plus test data designed? This should help you to design the DataStage processing. Without completely understanding your requirement I think you would use something like five consecutive Lookup stages, each with the "not found" rule...

Server job (as posted) or parallel job (as marked)? In either case a Search should reveal some useful information.

RowProcRunningTotal is a transform function (which is to be found in Routines), not a Transform.

Chinese and Swedish at the same time, or separately? Unicode (UTF-8) should be able to handle both. Specific character maps probably will not, and this means that View Data probably can not handle both at the same time either. But it's only a viewer, and won't affect processing - find some viewer th...

Column analysis takes as long as it takes. It is affected by several variables, not least data types and variability in the data, so it is not possible to estimate in advance how long will be required. Agreeing to a fixed time window was probably a Bad Idea unless the window is generous. There are, ...

Pretty much the same "stuff" happens in the background, but the "real time" interface expects a very small volume of data (for example one row or one small XML document) which it processes and returns the result through a web interface. The big difference I guess is that, with re...

You have marked the job type as "server" but your description suggest otherwise. Do you understand the concepts "blocking column" and "matching column"; that is, what each means? If not could I suggest you take the QualityStage Essentials training class?

There are things in your data that might cause a segmentation violation including, though not exhaustively, trying to load a null into a non-null column or trying to load more than N characters into a Char(N) or VarChar(N) column (you would probably generate the signal in the ODBC driver in these ca...

The clients should be able to install on any file system type. You not only need NTFS for the file system where the server componentry is to be installed, you must also have Windows XP Pro. DataStage simply will not install on any other Windows XP (and, technically, should not install on any, since ...