DSXchange

Did you get PAID ?!!

Please advise HOW it was resolved, to aid future searchers.

You might also mark the thread as Resolved.

I sense an enhancement request coming soon!

Find the directory in which dscapiop is located and make sure that this directory is included in your shared library search path environment variable.

I believe that neither sort keys nor partition keys are stored in Data Sets. There is no need; the data are stored however they arrived (partitioned and sorted). Therefore, I believe, you need to track back to the jobs that created each Data Set and determine from its log which APT_CONFIG_FILE value...

You are leaving APT_STRING _PADCHAR environment variable set to its default value (0x00). If you want space padding, bring this into your job as a job parameter and change its value to a single space character or, if you must, 0x20.

Backslash may also work as a quote character. It does in server jobs. Try it and let us know.

Write yourself a little routine.

Copy is the cheapest stage for renaming columns.

What is "c0" in your job?

And when you get to version 8 there is a whole suite of monitoring and resource estimation tools available in the product, with which you can exhaust all the toner cartridges in your color printer!

Definitely you need to use a Sort Merge collector. (Auto) will collect the rows round robin; the fact that the rows on each node (partition) have been infividually sorted by the Sort stage is ignored by (Auto) but acknowledged by Sort Merge collecting algorithm.

Search for "vertical pivot" also.

You use appropriate data type conversion functions, such as StringToDate() and DateToString(). The format string supplied with each of these specifies how the string is formatted.

You *should* be able to use cat file1 file2 file3 as a filter command in a Sequential File stage - the stage reads stdout of the cat command.