DSXchange

DSStopJob is not a command. But you're on the right track. A Terminator activity would do it.

Wrap your code in Code tags so we can see the indenting. The typical reason for infinite loop is that there is a code path that does not update the loop index variable.

IS that the actual PATH variable for the user ID executing your DataStage job? (Add ExecSH as a before job subroutine to execute the id command to find out who this user is.)

It might be high-end Windows but it's not high-end UNIX. With UNIX you can get far more powerful hardware - at a price, of course.

The other thing I like about UNIX is how rarely you need to re-boot anything.

Did you try toSearch?

An exact match search for "already bound" achieved 12 hits (including this thread).

Because of what? There are a couple of errors in the output. Did you review/remedy where it suggested that you do so? That it can't find the MKS Toolkit sh.exe program is probably an issue with your PATH environment variable (command search list). Inability to execute on remote nodes is usually inco...

Well ISO8859-1 only goes up to 255, so that will never work. What happened when you tried UTF8 as the map (and did you set UTF8-CS as the client-server map in this case)? Are you seeing the ? (unhandled character) only in View Data, or also in the output file? Finally have you tried using the pseudo...

Yes.

In fact, if you want the entire composite key, it's easier and faster. The system variable @ID accesses the entire composite key. However, this is necessarily unique anyway - it's the primary key.

Do you have NLS enabled?

You can more easily use UniVerse table in this scenario.

Look at the log through Director. What was the last time the job was run? (You may be in for a surprise.) Look at DS_AUDIT for this job. When was the last time that this job was modified? Unless the log is opened in Director or the job is run, the date/time modified/accessed on DATA.30 should not ch...

Welcome aboard. The answer is yes but, for a small enough number of rows, you can get away with unsorted input. The stage even has an "ignore unsorted input" option if I recall correctly, to ignore the fact that the data are not sorted. If you don't have sorting of the data specified on th...

There are actually three files in the directory, DATA.30, OVER.30 and .Type30 (hidden). The first two are binary files containing a header and the hashed file's data, the third is empty but its existence notifies DataStage that this directory actually implements a dynamic hashed file. Don't ever del...

You probably need to set up the routine definition in that particular project. Only defined routines appear on the drop-down list.

That is precisely what SortMerge collector does.