DSXchange

I needed a bigger hash file than the normal 2gig 32bit default, so I created a 64bit hash. It is being used to aggregate a 15 million row sequential file and then read in subsequent processes. In all processes using this file, I am getting warnings and a phantom error stating: DataStage Job 6968 Pha...

I have a job that updates a Federated mainframe view which does not use a "Where" clause. When we had DB2 version 7 on the DataStage server, there wouldn't be any warnings. We have our sequences set up to stop whenever any of the processes produce Warnings. We just upgraded our DS server t...

I have a process that has multiple inputs from a single transformer into a hash file. I have set the transformer link ordering. On the first input link into the hash file, I have the hash properties checked: Create File & in options, Delete file. The 2nd & 3rd input, nothing is checked. I am...

I still need to test all the possibilities, but what I have found is if the check box "Automatically Handle Activities that fail" is checked, the INIT Seq will abort, along with all the sub sequences. If it is unchecked, only the sub sequences abort and the INIT shows Finished. So to answe...

It seems how ever I wrap it, all the sequences seem to abort or maybe I'm not calling it correctly. How can the INIT sequence not be affected by the sequence it is calling? I have tested the below code, set in a "control" job, that can be run before the "Main_Sequence" is schedul...

I have a multi-job setup in which a "Main" sequence calls a "Sub" sequence, which runs actual processes. If a process fails, the "Sub" sequence aborts and the "Main" sequence aborts. I have an Execution Action on all sequences, "Reset if required, then ru...