DSXchange

Yes, but it's total overkill. What the Transformer stage generates (in version 7.5.2 and later, anyway) is essentially an operator (the same as what a BuildOp is).

Challenge the requirement to use a parallel job. You are reading ONE FILE, a sequential operation. You are writing ONE FILE, a sequential operation. Parallel execution is a waste of time in this case, and you don't need the unnecessary overheads thereof. Server jobs will be supported into the indefi...

mmap is memory map. I'm guessing (because you did not post complete pertinent information) that a tsort operator is involved. It was unable to get enough memory to perform what it needed to. Research (via help, DSXchange search or the manuals) how to allocate more memory to sorting operations.

A search of DSXchange will uncover suitable routine code.

What proof do you have that the child job completed successfully, if you can't open its folder in Director?

Do the child jobs invoke after-stage or after-job subroutines?

Is your repository database in need of re-indexing?

The deadlock daemon will not start automatically until DataStage is re-started. The job may still lock. The deadlock daemon will clear that lock, but it may take quite some time - the daemon only wakes every 15 minutes (by default) and it usually requires two cycles to clear locks held by redundant ...

&HOLD& is a directory. However the "&" character is special to the shell, so needs to be quoted or escaped in operating system commands such as cd. cd \&HOLD\& or cd '&HOLD&' This is not a DataStage requirement - it is an operating system requirement. A FMT specification ...

Logical partition. Nothing whatsoever to do with DataStage.

It's not possible. You could certainly change the source code dynamically, even compile and link that, but the job would already have connected to (opened) the older version.

Preferable would be to build the flexibility into the function code itself.

You can right click in the background area of the Transformer stage and gain access to these kinds of functionality through that menu.

The optimal connection will be had through the DB2 Connector stage (new in version 8.0). You should be able to connect to a local DB2 instance without the need for DB2 Connect software. But to connect from UNIX to DB2 on Windows you will need this software. Your DBA should have it, and be able to in...

Just look at the generated OSH or, even better, the score.

What "control characters" are you getting in your data?

Good. Now verify (using Link Execution Order) that the left and right inputs are as you believe them to be. Your belief that "a left outer join should return all rows from the left input with either matched columns from the right input or nulls for these columns" is correct. If there happen to be nu...

Change the file dictionary from MD4 to MD44 (or MD4P if your data already contain a decimal place character).