DSXchange

A Pivot stage goes the other way (columns to rows). What you are attempting to achieve is called a "vertical pivot" (rows to columns). There are several ways to achieve a vertical pivot in DataStage - a Search of DSXchange will reveal them.

I suspect that the "block" referred to is an unknown MQ message type (header?) rather than anything within DataStage.

Your original question specified five. I answered for five.

Adapt to suit the maximum possible number.

You can add a job parameter to the controlled job but not to its controller. However, under this design there is no way that you can assign a value to that parameter - it will always take its default value. If you require the ability to supply a value to that parameter when run from the controlling ...

I still don't understand what point you are making.

The default report includes all the activities in a job sequence, and you can create a stylesheet to have them displayed as you wish when the generated XML is converted to an HTML document.

OK, next time it happens go to the Processes tab in Task Manager, make sure that the CPU column is visible and click its heading to sort by CPU. Identify the process that is consuming too much CPU.

I think this could most easily be done in a Transformer stage. But, yes, you could create some PAL to reparse these patterns.

Of course it's possible. Use a Switch, Filter or Transformer stage with five outputs to Sequential File stages.

One of the tools in the standard Toolbar is "snap to grid". If this is enabled, then every stage you place will have its upper left-hand corner aligned with an intersection of the grid (there is another tool that enables display of the grid). This is the easiest way to align stages (until you resize...

I can not correct you because, frankly, I do not understand what you wrote. Could you perhaps attempt to rewrite it in a less opaque style?

This error can also mean that the job is already running. Are you passing the (a unique) invocation ID through to the job?

Some database products, such as DB2 version 9, have inherent data compression capability.

Open the Designer and click the Job Report tool (the one that looks like an Internet Explorer icon). You can create your own stylesheets to govern the format of the reports thus produced.