DSXchange

This is a client (Windows - OLE Automation) issue, and so can not readily be classed as "server" or "parallel". Search the forum for "OLE Automation". Somehow the connection from DataStage Designer to the DSObjects control that exposes the objects has been lost somewhere in the Windows operating sys...

It's rare, but this one can also occur if the process table on one machine has become full, so that no processes can be started.

Do you really want to do this in a Transfomer stage, so that you get the (same) link count from the first job for every row processed in your second job? (Or are you perhaps initializing a stage variable, in which case I withdraw the question?) You can get as many row counts as you like in a single ...

If the maximum number of paths you will have is finite and manageably small, create that many output links. It doesn't matter if no rows are passed along any particular output link. In your plan, you want to process the same data N times, where N is the number of values in the hashed file. This is n...

Don't use a loop at all. Use one job in which the Transformer stage has five outputs, writing to the five different files. Use constraints based on the return value from the lookup to determine which rows are sent along which links. This way you only need to process your source data once. This will...

You could avoid the overheads of opening an operating system shell and of starting up the dsjob command by using the DataStage BASIC function DSGetLinkInfo() directly in your BASIC code. You would, of course, need to attach and detach the finished job, but this is a smaller overhead than your approa...

This is both a caring and a sharing place. How did you solve it? Help out others who might be searching for this solution in the future!

The best source is the authoratitive source, the DataStage BASIC manual and the on-line help.

You can never really know the number of records loaded in a Transformer stage; only the number of records sent to the data target. The remainder depends on too many factors to post here. Why do you want to do it this way? The counts are in variables @INROWNUM and @OUTROWNUM in the Transformer stage;...

Welcome aboard! :D There are two answers, one for technical metadata, the other for process metadata. For technical metadata you can, for example, export to MetaStage from DataStage (or import from MetaStage) using the MetaBroker (which you can profitably think of as a specialised filter for viewing...

These are separately priced products from Ascential (mainly to pass on the licensing costs from Siebel and SAP), and come with their own documentation when purchased.

You could probably approach Ascential for the manuals only.

Welcome aboard! :D Check the job log file for warning or error messages. For example, by default a DataStage job will abort if 50 warnings have been logged (you set the limit when requesting the job run). Or it may be that the Oracle rollback segments is too small, in which case there will be an Ora...

Welcome aboard! :D The only thing you require is for the name of the hashed file to be "registered" in the DataStage project. If you created the hashed file with Account selected, you need to do nothing - simply load the hashed file's metadata into the UV stage and you're off and running. (Import th...

Were there any other warnings or errors logged? What does your job set out to do? Can you give a brief outline of its design (stages used, and source and target data sources (text file, database, etc.) particularly)?

With just the error message there's not really much to go on.

Easy, yes, but harder than seeing it in clear in a ps -ef report!