DSXchange

There's no requirement to have one, the same as for the Sequential File stage. A complex (or simple) flat file can legitimately consist entirely of duplicate lines.

This error can indicate, for example, a faulty memory chip. Or quite a number of things outside your, or DataStage's, control. Learn somewhere about the various signals that the operating system can raise.

What you seek to do is only possible by making reference to the hashed file through a UV stage, which handles the separate logical key columns as if they were independent. At the very least, this approach will require a VOC entry for the hashed file; to be useful it will also require indexing on the...

This does exist in the IBM class DX800 (what's new in 8.0). I don't have it with me at the moment - maybe someone else can unearth it.

In version 7 DataStage the MQ server needs to be co-resident with (on the same machine as) the DataStage server. Does your configuration satisfy this requirement?

The parameter in question is T30FILE. Your search will find posts that indicate what you must do in order to change it.

Is there a ROOT entry in DS_JOBOBJECTS for a job with name of TEST?

If I recall correctly, if you use IPC, Link Partitioner or Link Collector stages, you must enable inter-process row buffering for the job. Their operation relies upon it being available.

The big one is that the server Transformer can perform lookups (supports reference inputs); the BASIC Transformer stage does not. BASIC Transformer stage is not in the parallel job palette by default (deliberately). It can be found in the Stage Types branch of the Repository, and moved into the Pale...

What I meant was that, if the new value is Y then the previous value must be N and if the new value is N then the previous value must be N. The domain of this column is ['N','Y'].

You can't. It's all or nothing for a job.

DataStage jobs manage end of data via a token that is passed through the job. I believe this will be exposed as a system variable in a near future release (@END.OF.DATA ?).

Director's auto-refresh interval can be set in Tools > Options. Auto-refresh was (as I understand it) removed from Designer in 8.1 when a new, apparently faster, way to generate painting of the design image was implemented. Manual refresh is achieved through Repository > Refresh. Administrator clien...

What makes you believe that larger buffer sizes relate to "performance" (whatever that is) being improved?

Do you seek a completely general solution, or merely one that operates solely for US time zones?