DSXchange

Search the forum for "vertical pivot". It may be easier, if your database has one, to use a table transpose function.

Please post the exact error message. The part message in your first post suggests a problem in a Transformer stage, not in an Aggregator stage.
Reset the aborted job and, if one appears, post the detail of the "from previous run..." message.

Yes.

Routines called from job sequences are, in fact, server routines not parallel routines. There are many examples posted here, search for the word FUNCTION. As to how to write them, you must begin with a plan of what you want to accomplish - the input argument(s), the algorithm and the return value. O...

D'accord.

Not you. You're not the OP, so could not have marked the post as resolved.

With neither statistics nor knowledge of the internal sort algorithms available to me, I feel it would be unwise to offer an opinion.

Given your original scenario, the answer is no. You can only use -param options for parameter names that exist in the job. What you can do is to have dsjob run a job sequence that runs the job. The job sequence can accept all the parameters, and only pass the required ones to the job. But, if it's u...

Are there any line terminator characters in your query?

You have marked the topic as resolved. Please post the resolution.

Why? I believe that's an urban myth. The mere fact that the manuals use dstage in their examples is an artifact - after all, it's only a group name. Several of my client sites have in-house UNIX group naming standards and follow these: the group that has access to the DataStage software is documente...

The Sort stage in server jobs is universally acknowledged to be horrible. I'd suggest getting a UNIX emulator for Windows, such as MKS Toolkit or Cygwin, and using the sort command therein.

Had you mentioned XML in the original post, you would have received that advice much earlier.

Permissions in the project directory and/or umask settings for the users are inappropriate.

Wrong. You can change execution mode to parallel on the Advanced tab of the stage properties. Indeed (at version 7.5.1A) the default execution mode for an External Source stage is parallel. The same is true of the External Filter stage, but I'm not sure how this crept into the discussion.

Probably not. The problem is that you need mechanisms that are legal for SAP. Only the SAP Load and IDOC stages give you this. Of course you could generate text files from DataStage and use internal SAP utilities to import those data. But that needs more layers of management and control.