DSXchange

What you describe as what you're doing are the correct steps, so we must agree with you that it does not appear to work properly in version 7.0. Any reason not to upgrade to a 7.5 release?

Premium membership costs only a few cents per day, and helps to fund the bandwidth costs of DSXchange. It's definitely worth it, not just to be able to read all of the premium posters' posts, not only because you are helping to keep this site operating, but also because of more goodies for premium ...

ORDER BY is definitely the preferred choice if the column on which you are sorting is indexed with a B-tree index, which is already stored in sorted order - the sort can simply traverse the leaf nodes of the B-tree. This is mega-efficient compared to actually sorting the data.

There is no HTTP download/upload functionality in unadorned DataStage. With an HTML-enabling PACK you may have more luck but I'm unable to check that today. Search IBM web site.

See Match Concepts manual page 5-46 and following.

You have these in parallel jobs (Compress and Expand stages). You have this indirectly in job sequences, via the Execute Command activity. I don't believe this request will get very far.

Server edition is completely irrelevant here. Whale, if this is in a Transformer stage can you take a look at the generated C++ code? For job number xxxx this will be in a sub-directory called RT_SCxxxx in the project directory on the server. I'll see if I can find a 7.5x2 system tomorrow or Friday.

Then you must make sure that your search paths find the Visual Studio .NET executables before they find the MKS Toolkit executables.

The number of node definitions - the number of node names - in the configuration file is the number of partitions, unless execution of the stage is constrained to fewer nodes for example by executing in a node pool or in sequential mode.

In the toolbar there is a tool with an A on it. This enables/disables display of annotations. While display of annotations is disabled they are disabled not only in the design area but also in the Palette. Click on the A tool and all will be well. Hover the mouse pointer over it to get a tool tip.

Check to see (a) whether they have a user-written routine called DSShell, or (b) are referring to some other routine such as DSExecute. Given the error message I suspect the former.

What is DSShell ? It's not mentioned in the DataStage BASIC manual and it's not mentioned in DataStage help.

We have installed Datastage EE on a WINDOWS 2003 machine with a single CPU. Whenever a parallel job is run , and is successfully completed , the colour of the links donot turn to GREEN and the transfer rate is displayed as (0 rows/sec , 0 rows ). Hence, by seeing the log and data of the output stag...

Please write in English. U is one our co-participants here and, while it is true that U can customize link colours, I am sure that is not what you meant.

It's worse than you imagine. Seconds are rounded to whole seconds before the calculation is done. The clock starts when the job starts, not necessarily when rows start flowing (but using the stage timings is closer to "true" (for some value of true). The CPU figure in Monitor also falls foul of the ...