DSXchange

This is what's called a horizontal pivot and is exactly what the Pivot stage is intended to do.
Look in your manuals for Pivot.pdf which explains how to use it, with examples.
Search the forum for an example of pivoting the constants (P1 through P4).

Arnd, T30FILE does not govern the issue of file units; this is managed purely from the rotating file pool for all file types. What T30FILE does is to specify the size of a table in shared memory (visible via smat -d ) in which the current sizing parameters of each dynamic hashed file are kept, so th...

Your range values are too large for integer arithmetic, and the leading zeroes need to be preserved. Search the forum for the code for my OpenSequentialFile routine and implement same. Then pre-process your file with the following before-stage subroutine. In its input value field supply the pathname...

For larger volumes of data a well-tuned static hashed file will out-perform a dynamic hashed file during the load phase. A dynamic hashed file where the minimum modulus has been appropriately set will, however, get close to the load performance of the well-tuned static hashed file. It's really just ...

When you are performing a lookup in DataStage, whether from this routine or from a Transformer stage, failing to find the key value will result in each column on the reference input link being set to NULL. In this it behaves in exactly the same way as does a left outer join in SQL, it guarantees tha...

Apart from buying more licences, there's no way to suppress this warning.

Hashed File Calculator is to be found on the Windows client CD, in a folder called Utilities\Unsupported.

If it's two hex digits per byte, you might also investigate the "MX0C" conversion with Oconv() function.

Last year they did "Ascential World Down Under". For a number of reasons - mainly Ascential presenters not being able to come at the last minute due to the IBM thing - it was a fizzer. I doubt they'll even think of doing it again. Throughout the rest of Asia (both east and south) it is my experience...

The PX configuration file is about "processing nodes", which are logical entities, but which each refer to some processing capacity and associated resources. You may investigate distributing resources onto mounted file systems, and you can employ specific resources (for example the db2 resource) ont...

Welcome aboard! :D Every job in your project has a unique number; the job where this problem occurred is job number 378. (You can map names to job numbers in the DS_JOBS table, but I'm sure you know which job it is - its status is Aborted.) "Phantom" is simply DataStage's name for a background proce...

We don't do "urgent". You have been posting here long enough to know that.

What happens if you rename the old job then import into the old project?

Post your code. You definitely don't need a cd command. Further, DSExecute opens a new shell (in which your cd command would be performed) - that shell closes before DSExecute returns. Please specify exactly what you're trying to achieve. Is it, for example, to read all files in a folder? You will n...

You will not be able to compile any routines in a parallel environment version 6 on Windows.