DSXchange

Build stage. You need to write your own decryption code. If there is a command line decryption utility you could use an External Filter stage.

UV or Hashed File stage querying DS_JOBS excluding any where name begins with a "/" or "\" character, returning columns NAME and CATEGORY (both VARCHAR).

Welcome aboard. :D
Can you please post the actual Filter command? Since the Sequential File stage reads stdout from the filter command, this is unexpected behaviour. Does the sort take quite a while? Perhaps the Sequential File stage is taking a timeout and processing no rows at all?

Tables with DS_... names contain only design-time information; they contain nothing about when/whether the job has been run and how successfully. You can certainly obtain the values of the Table link property with your query, but not whether they have been loaded. That would probably need something ...

Passive stage types (such as Hashed File stages) can not open their output link(s) until their input link(s) are closed. Until the hashed file is fully populated and the write cache flushed to disk, the remainder of the job will wait.

The error messages make it clear that there was a network error. Fix that.

Where did blah.exe come from? It's not in my original post (which has not been edited). Was it an attempt at humour? Perhaps you left out the funny part.

The reason that .dshome is not created for an -itag installation is that such an installation implies that more than one server version is being installed on the machine, so a more flexible mechanism for identifying the DataStage server - namely the DSHOME environment variable - is required as the g...

Possibly. It rather depends on what the job does. But there's no flexibility with a hashed file of this size. You've already indicated in another post that you need every column and every row that you're loading into the hashed file - but you might like to verify this assertion.

Use a bigger data type - maybe VarChar(4096)

Dump the score (set APT_DUMP_SCORE) and determine where the error is being generated. Fix that.

It's not a server job, is it?

Can you inspect the generated Job Control code to try to figure out what's happening?

Welcome aboard.

The easiest way is to use DataStage EE MVS edition, which can handle IMS directly. It has an IMS stage, and allows you to predefine IMS databases and viewsets.

It's primarily a matter of understanding what gets deployed to the server. There's nothing hidden - everything is in the form of scripts, file dictionaries and rule set tables (text files all). There are six directories on the server, within the project directory itself. Inspect the contents of thes...