DSXchange

Everything isn't fine. Check the hashed file stage again, but this time scroll right in the columns grid. You will see that the fields are referred to by position, not by name. Therefore, when you changed the order, it wasn't happy. Import and load the UniVerse table definition from the hashed file ...

That may have been faster as

It seems to be the usual economic supply vs demand problem. If they won't increase the supply (utility limit, whatever that is), then you need to reduce your demand (fewer concurrent tasks) or justify an increase to the supply. Probably you need to find a more intelligent strategy for scheduling you...

SAS is a separate PACK, as far as I am aware.

It's called something obvious, like ds_xpsp2, from memory.

If you specify the quote character as a field level property, it will find the opening quote and scan characters into the field until the closing quote is found. Then it will resume its search for delimiter characters.

OK, misunderstood your requirement. The big table is the reference data, is that correct? It contains columns A_ID, B_ID, C_ID. What happened to data set D? Does it have a key? Your requirement really isn't clear. Let me take a guess. Lookup a row from stream B against A. Lookup a row from stream C ...

IBM (and other vendors ) do offer "startup" and "best practices" advice. From IBM you can get a consultant armed with Parallel Framework Best Practices which was produced by the IBM Information Integration Solutions Center of Excellence in 2Q2006. Presumably the other vendors provide advice along th...

Are the text strings that contain delimiter and terminator characters quoted? If so, DataStage can manage them, if not it can not, so you will need "them" to create a file in a legal format, or pre-process it yourself.

IBM tends to support things for a lot longer than smaller vendors. You can still get support for FORTRAN IV and RPG!

Is your client Windows XP sp2 and, if so, do you have the requisite patch for DataStage?

What you're getting is not really a hang, it's impatience on your part. DataStage has to populate a drop-down list of all job names. At the same time it gathers information about the parameters of each, so as to be ready to load the grid when you select a job. Inefficient? Maybe, but that's how it w...

Welcome aboard. :D
Thank you for useful information.

1) Not necessarily, though it is the default behaviour. You can use node pools in the Sequential File stage to cause them to be created elsewhere. 2) You can use node pools in the Data Set stage too. If the node pool does not include the conductor node, then the control file should be created on the...