DSXchange

Why not a Median routine that is a transform function? Maintain the sorted dynamic array in a variable declared to be in COMMON (so that it persists between rows) and returns the "median so far" as each row is processed. Performance? Bah! We're talking functionality here. You'll have the median of t...

In version 7.x you will need to invoke your QualityStage job from a DataStage job through the QualityStage plug-in. The DataStage job is set up with RTI Input and RTI Output stages, and published as a web service. The appropriate manual is the one that comes with the separately purchased SOA Edition...

In version 8.0 the dialog box tells you that the job is locked by another user and gives you the opportunity to open it in read-only mode. If you choose not to, behaviour remains as at version 7.5 and earlier.

Having Yes, No and Cancel on this dialog is desirable.

It's not there in version 7.5x2

If you're running on Windows XP sp2 do you have the patch? Search the forum for details.

Which is exactly how Field() works.

What's wrong with using the Change Capture, Compare or Difference stage to detect change, and Surrogate Key Generator stage to generate surrogate keys?!!

Cleanup is not available in all versions.

kcbland wrote:Once 8.0 comes within my grasp, my associates and I will revise our utilities accordingly.

So it's really Caveat Vendor then?

Cascading lookup CAN be done.

But you can not construct it with the GUI; on the second and subsequent reference key expressions you must type in the qualified name of the return column from the earlier reference input link.

It will remain red, but it will compile and it will work.

Run the DS.CHECKER command. It checks for partial definitions, and deletes any repository job tables unrelated to a job.

Also, if the definition of a Transform changes, every job that uses it has to be re-compiled, whereas if the logic of a Routine changes, only the routine itself has to be re-compiled (unless the number of arguments changes).

A hashed file is a way to implement a database table. You can have multiple streams inserting rows into it.

There is no need at all for a Link Collector stage.

It was not always thus. I wonder why they restrict you to those drivers?

Check that every directory in the pathname exists and that you have sufficient access both to read it and to use it in a pathname.

Check also that the Lookup File Set was successfully created, and that its LFiles have not subsequently been deleted by some zealous operator.