DSXchange

Server jobs support implied decimal.

That was the original intent of the User Group Central forum. It was never used.

Stage variable svTrimmedString (type VarChar(8)) derived as
Output column derivation

No, but your support provider can. And it should be free.

Set up a stage variable (type VarChar(8)) to contain the trimmed string.
Construct the output string with sufficient leading spaces (1-Len(svTrimmedString)) then the trimmed string.

Is your client Windows XP sp2? If so, have you installed the xpsp2 patch for DataStage?

Use the DS.TOOLS menu or the Cleanup Resources facility in Director. If you're not the Administrator, then get the real Administrator to do it - it's an administrative task. The real administrator might also like to try manual execution of dsdlockd -p command.

Search for "vertical pivot".

The Pivot stage in version 8.1 (early 2008) will support both horizontal and vertical pivoting, according to the DataStage roadmap presentation at IoD 2007.

I don't understand how spaces are even possible in packed decimal representation!

Not easily. You could echo the header to the file in a before-job subroutine and then set "header row" to False in the stage, which would then need to Append to the file.

You monitor your jobs, and determine what percentage of resources is required for each. Note that you assumption "one process per job" is way off - it's more like one process per stage plus one process per node plus one. Based on the percentages you can figure out how many nodes is appropriate. It w...

I meant uvodbc.config. That's why I said uvodbc.config.

Even though you can not connect using DataStage clients, you can still connect with telnet, and you may be able to connect with DataStage Administrator client. Try each of these to determine whether your disk is full.

Create the directory.

Specify this directory's pathname when nominating the directory in a Hashed File stage.

Use of a job parameter for the hashed files' directory pathname is strongly recommended.

I know of no function called SetWarningLimit().
Like job parameter values, job limits can only be set before the request to run the job is submitted.