DSXchange

Technically there's no difference which database you choose for the metadata repository. Therefore the only pros and cons will be based on some kind of business case.

Most of them can be deleted for that very reason; when a job finishes successfully its file in &PH& probably only contains two lines (started and finished) so any file with only two lines can be purged. The file names within &PH& include the date and time of the run (in DataStage int...

DSINCLUDE is local to the project.
UNIVERSE.INCLUDE is the DSEngine/include directory (Type 19 file).

Actually most recent run parameter values should still exist, in the job record in RT_STATUSnnn (if my memory serves me correctly).

You can generate any value that's legal for the data type of the target column.

In 8.7 it is possible to reverse engineer jobs into FastTrack mappings (provided that everything in the job is supported by FastTrack).

Haven't researched it that deeply yet, but obviously they will have to use some mechanism for spawning processes. Parallel jobs still use processes (rather than threads) when running on Windows. As, indeed, do server jobs.

Please note that DataStage for Windows version 9.1 is not built on MKS Toolkit but, rather, uses direct Windows system calls.

If you've started relying on UNIX commands and you're on Windows, please consider this point as part of your upgrade strategy.

Our workaround is to publish Candidate terms and to educate our people about the meaning of various statuses (Standard, Accepted, Candidate or Deprecated). They've worked out that they can use Feedback from any term to suggest other terms. Once they've done that once, they have the standard email ad...

Division by zero is undefined. Therefore it does not make sense to ask what value gets assigned. DataStage (correctly) throws an exception. It's up to you to check the divisior if there's any chance of it being zero.

1. A left outer join is a right outer join with the left/right inputs transposed.

2. No. But you can edit the generated job subsequently.

Quote Character is not enforced. You could read specifying Quote Character = None and perform your own checks that Left(InString,1) and Right(InString,1) are both double quote.

Well done.

Everyone should put this thread into their Favorites.

Please report the exact and complete error message.

What happens if you execute the dsjob command while attached to the actual project directory?

We have already lodged a similar enhancement request, though implemented slightly differently. We simply asked for the Feedback button to be available at all times, not just when viewing a term.