DSXchange

If you're looking for a website from which you can obtain the client software you're out of luck. There isn't one. You must buy the software. With it you get full and complete installation instructions. Whether or not "they" will sell just the client is problematic; the client alone is totally usele...

You can create a routine to perform either of the commands Kim suggested, and use the routine's return value to drive - perhaps - a nested condition activity in a job sequence. It really is difficult to answer such a vague specification.

So... what has changed between when it was working and now?

Be prepared to look outside the job - even if nothing has changed in the job, something has clearly changed somewhere!

You can inspect the code produced by compiling the Transformer stage to see how it's done there. However you don't have access to the result of the "Get" function, so there's no convenient way for you to do it within the Transformer stage. Ken's suggestion is a good one; after all that's what the Ag...

The compiled code from a server job is not executable by the native machine; rather it is executed in a 'virtual machine' called the DataStage Run Machine. This assists in platform portability, and explains why you can't install an AIX DataStage on an HP-UX machine; the Run Machine is different. It'...

What value is returned by STATUS() when OPENSEQ is executed? The ELSE clause can be taken for a number of reasons - read the manual on OPENSEQ. For example, of C:\DS305Files does not exist, OPENSEQ will fail, you will not have a valid file variable, and CREATE is therefore doomed. I don't use CREATE...

The default of 50 can be changed in Director. Choose Tools > Options. Find Limits.

Don't use WeofSeq if you're planning to read from the file. WeofSeq writes an end-of-file mark at the current location, which is beginning of file if the file has just been opened. This truncates the file to 0 bytes.

Read the help on DSGetJobInfo - there is a different argument (new in version 7.x??) that allows you to demand the interim status (that is, the status as if the job had already finished).

The reason DSJobReport is different is that it is actually executed after the job has finished.

You definitely need XP Pro. If that has SP2, you will also need a patch from the vendor (through your support provider).

A Data Set is partitioned so that there is exactly one partition on each of the processing nodes defined for the stage whose input link specifies the partitioning algorithm. By default this is the same as the number of processing nodes in the configuration file associated with the job for its curren...

When you select, ORDER BY the pivot keys. This will help a little. The only other suggestion I can make is to capture performance statistics for the Pivot and Transformer stages; this will highlight any "hot spots". For example, how complex are your Transformations? Statistics gathering is enabled o...

Beware that this symptom can also be seen if someone creates another entry into the dynamic hashed file directory.

The directory must contain exactly the three files DATA.30, OVER.30 and .Type30.

The message "rb_tmu not found" indicates that what I suggested earlier (that the parent directory $RB_CONFIG/bin is not in your PATH). Modify the dsenv file so that all required Red Brick environment variables are set for DataStage processes. There is no such thing as rb_ctmu. Red Brick has: rb_tmu ...

The correct NLS map for hashed files is always NONE. This is because hashed files are internal to DataStage; the data have already been mapped from the external representation by the time they get into a hashed file. Had you mentioned in your original post that a hashed file was involved we probably...