DSXchange

What exact release please? You ought to be able to apply buffering to an active-to-active link, but there were some issues in the early 7.x versions.

You can skip as many rows as you like, by setting the Skip property. I take it the Sequential File stage is executing in Sequential mode?

As with everything, it depends. If no other users are going to be creating new keys in the database, then you're free to generate keys in DataStage. You could create a simple job to retrieve the next key value, pick that up (from user status area or from a text file) and use that value as a job para...

If you have been diligent about recording the dependencies (this is what the Dependencies tab in job and routine properties is for), then Version Control can be asked to pick up and promote all dependent objects automatically.

A search will find an after-stage subroutine that you can use. Generate the base name, then use the after-stage subroutine to change the name. Since the after-stage subroutine is not executed until all rows have been processed and the file closed, this is an entirely valid approach.

What's wrong with using a DataStage job to do that? Even though it's only a one row job, you have everything using the same tool, which suggests easier long-term maintenance.

Although my name is not "u", and the second person personal pronoun is not "u" either, it is the case that the OCI stage invokes sqlldr.

Do you have any proof (precise and accurate comarisons) with which you can berate the vendor? That is, do you have timings for exactly the same job using exactly the same data, sources and targets, on exactly the same sonfiguration? Or is it just an impression?

Hi Ray I have just bought the membership for charter members ,but still I am not able to view all the contents ,do you have any idea how much time it will take to activate the membership. Thanks Arif I thought it was immediate. Contact either the Editor or the Webmaster (choose Contact from the men...

You specify parallel job, but post in the DataStage TX forum. To what kind of DataStage implementation are you really referring? Have you sought advice from your vendor/account rep?

Your job will parse each line from the sequential file into a row (a set of columns). These can then be transformed/enriched within the DataStage job, which continues to pass rows through the job design. When you invoke your stored procedure, you do so once for each row processed, supplying column v...

NLSMODE can not be changed without restarting DataStage. If DataStage has not been restarted then NLSMODE has not been changed. It is a tunable parameter in the uvconfig file. After changing the uvconfig file you must regenerate the disk shared memory segment image using uvregen before restarting Da...

OK, since it's from one of "their" routines, you may be out of luck. I don't have access to DataStage at the moment, but am fairly sure they have not supplied source code for DSWaitForFile. If they had you could modify it. Even so, it would not be impossible to create your own (one that does not gen...

OK, poor choice of word. I'd just emerged from slumber! I apologize unreservedly.

There's some good news in Hawk. Instead of individual parameters you will also be able to use a "parameter set" - a set of standard parameters that can be loaded into a job/job sequence design in a single operation, and stored in the Repository as a single re-usable component.