DSXchange

"Count of delimited fields" technique.

You must specify the column in which the 01 level item begins. By default it's set to column number 8. This is not the case with your FD.

Etiquette Note
It would have been better to start a new thread than to resurrect this very old one, even though the topic is accurate for your problem.

On the Format tab of your Sequential File stage what is defined to be the representation of NULL? Is this overridden for any of the columns in the Columns grid. Try changing the representation of NULL to, say, <NULL> then, in your expression, testing for a zero length string (or even for zero).

"Final delimited substring" technique.

What error codes are you getting? Grab the Intercall manual from the UniVerse web site - it has the most comprehensive list of connectivity error codes.

I have a vague recollection that you can't install DataStage on symbolic links - are there any symbolic links involved?

Individual DELETE operations tend to be very time consuming. There are also some known issues with DELETE on DB2 (you can read about them on the parallel jobs forum). Contact your support provider to determine whether a patch is available for server edition. You mention Enterprise stage. Does this m...

What version of DataStage?

Roles are assigned to groups, not to individuals. Please check your work. If you have properly assigned the DataStage Operator role, and that individual is not in a group to which the DataStage Developer role is allocated, then that individual will not be able to open jobs in Designer.

You must pass a timestamp (or NULL) if you are passing the row. The only way you can avoid supplying a value is to generate an UPDATE in which the timestamp column is not mentioned, or to avoid passing the entire row.

Make sure the hashed file is loaded with the first value (however that is defined). Usually, as others have noted, this can be accomplished by sorting the stream of data being loaded into the hashed file in reverse order; hashed file records are destructuvely overwritten, so it is the last written v...

How many CPUs are in your DataStage server machine? If this is a small number, and you are asking it to do so many things at once, is it any wonder it reports being overloaded? Can you juggle two balls? Three? Twelve?!! A design such as that below guarantees that at most two jobs at a time will be r...

Mainframe jobs in the MVS edition generates COBOL source code, and JCL for getting that compiled and run on your OS/390 system. Server edition does not have the capacity to create mainframe jobs. You still need some kind of process to get the data from the mainframe. Aditya has suggested one way; mo...

You can set up DB2 Connect to do this. Ask your DBA.

If you're going to use test -z filename you are more interested in the exit status (SystemReturnCode) than in the output o the test command (which is typically silent).

And even if there were, it would turn out to be dsapi_slave if initiated from a Director client.