DSXchange

It's a hashed file in your DataStage repository. The key value is the sequence name, while field 1 contains the sequence value. By what mechanism do you want to "get" that file?

Since MIN can only be a single value, your WHERE clause can be made more efficient (depending on whether the query optimizer does this anyway). Relace "IN" with "=" as the comparison operation.

What's wrong is that Ans must return zero if an OK trigger is expected to fire.

You must combine the two reports. The stage name is the link.

DSAttachJob() is necessary before issuing the run request with DSRunJob(). So retrying that function isn't going to help; it's still attached to the controller while it's running. Try creating a new server job, open its job properties then the Job Control tab. Select a job from the drop down list an...

Yeah, why? I can't think of any reason for wanting to do that. The number of keystrokes required to create the script is probably more than the number of mouse clicks required to delete the jobs using the GUI.

It would be sufficient to hash (or modulus) on zip. Sorting on the other two columns is beneficial to the correct operation on the Remove Duplicates stage, but all you need to ensure is that each distinct value of zip (the grouping column) appears on exactly one node. Round robin partitioning will n...

Nothing can be done in DataStage to affect the relative performance of two separate queries in DB2.

If you sort the file (so that the dynamic array is sorted) and use a sequencer (for example "AL") in the LOCATE statement, then the search will be on average twice as quick.

Three yellow cards?

Learn about operating system pipelining. In summary: command1 ; command2 command2 is executed unconditionally after command1 finishes command1 && command2 command2 is executed only if command1 finishes successfully (with an exit status of 0) command1 !! command2 command2 is executed only if ...

Why not just use tail -1 filename as a filter in the Sequential File stage that reads the file?

File > Generate Report is intended to provide the design, not the process metadata. Row counts are obtained using Director client, using File > Print to print any "active stage finishing" event. You can also use the DataStage API (DSGetLogEntry() function) to read a log entry. The DataStage API (DSG...

I contemplated a 15 paragraph answer to that question, but will settle on "I agree.".

I think this was necessary. Its been happening a lot in the recent past. I agree :D. C'mon I double-dare you to quote my message with your quote It truly isn't necessary. Of course, were you a disk space vendor, you'd probably make over-quoting mandatory. But it's frowned upon in every technical fo...