DSXchange

In your original question you stated that you had already created the hashed file so I took it as given.

Moderator: please move to parallel forum

Server jobs do not have a Join stage.

The command is dsjob - Search DSXchange and/or the manuals for more information.

Look for Delimiter String property rather than Delimiter property.

Server job (as posted) or parallel job (as marked)?

If you wish. Most stage types support sorting on their input links, but none offers the flexibility available with an explicit Sort stage.

The main thing is not to sort where it's unnecessary.

One of the major invisible things in version 8.0 is reduced startup time. There's not a whole lot you can do about it in version 7. That's one of the reasons I advocate server jobs for small to medium loads.

It's not possible. DataStage does not have its own login. If they fail to login to "DataStage" it means that they've failed to log in to the operating system, which is recorded automatically in syslog. Another example of auditors being ignorant whereof they speak.

Post your actual derivation expressions.

If you are paying for official support then you have a strong moral argument (and probably a legal argument as well) to demand that support.

IA tasks in version 8 run as DS jobs in the ANALYZERPROJECT project. Beyond that there is little information available, but the first thing I'd be checking is permissions (in that project) and credentials. You may need DataStage credentials as well as Information Analyzer credentials.

One at a time, using handle_null() function.

Note that there is an error in the Parallel Job Developer's Guide - the SetNull() function is only for the Transformer stage, not for the Modify stage.

If the database vendor's client software won't permit it, then tough.

If that's true it will (should) be in the StageTypes branch of the Repository.

Search - it's been done before.