DSXchange

Are the different instances using the same keys? If so, your problem is obvious. Use different hashed files (note: it's not "hash file") or unique keys.

In a before-job or before-stage subroutine use ExecSH to execute the following command:

Then make sure that the Sequential File stage that writes the file appends rather than overwrites.

Not without knowing the reason for the request. The best answer to such a vague question is "satisfactorily" - this is the answer Rolls Royce gives when asked questions about the power output of their engines. If it's good enough for them... There is no reason to know this information, and it's all ...

If you really are going to get millions of unavoidable warnings - though I can not see any good reason for such a situation - you can resize the log (once it has been cleared) to handle more than 2GB.

This will affect people's answers.

The files are expected to be in the QS project's Data directory.

Etiquette Note We don't do ASAP here. This is an all-volunteer forum; folks post as and when they can. If you want ASAP enrol with your support provider for priority service, and see how much "urgent" actually costs. A short answer to your question is that you define the file layout using QS Design...

Try appending " 00:00:00" (note the leading space character).

Use an explicit Transformer stage in your job (the invisible one that DataStage has inserted is still a Transformer stage, so the cost is the same). That way you will have full control over the stage name. The abnormal termination was caused by DSJ.STAGEINROWNUM not being defined. Add the following ...

Post your source timestamps - they may have fractional seconds.

Field() is supported in parallel Transformer stages.

Set the output trigger on the WaitForFile activity to "OK"; this means that it will not fire unless the file appears. Optionally create another output, and set its trigger to Otherwise; this will fire if the timeout expires, and you need to trigger some download activity (for example Notification ac...

Hashed files can be created or resized with 64-bit internal pointers to avoid the 2GB limit.

Data Sets and File Sets automatically adjust, by creating additional segment files.

How long is a piece of string? That's an unfair question, it depends on so many things, such as your hardware (especially CPU speed and amount of memory), parallelism, and what kind of operation you are performing. For example, a two file match may need to compare every row in one data set with ever...

It's too confusing. You'll have to change your name to Bruce.