DSXchange

When you connect any DataStage client to the DataStage server, the RPC mechanism (dsrpcd) validates the connection and starts a child process called dsapi_server that acts as your agent on the server. The dsrpcd process is typically auto-started when DataStage starts, and therefore usually starts as...

In that case you don't need to track the previous value (it will always be the "inverse" of the current value) - you need only to track the date of the most recent change.

Use ORDER BY in the extraction and use a Sort funnel to preserve the sorted order.

Check the pathname /Data/Response.dtd

For example, should it be /data/Response.dtd ? Does the DTD file actually exist? What permissions obtain for it? What permission does the executing process have to the parent directory?

The original post/subject suggests that it's a SCF.

dsenv is a text file. Look at the examples that are already in there. You need to set a value for the environment variable and you also need to export that environment variable (because dsenv is executed using a Bourne shell). Note also that there is no dsenv script if your DataStage server is on a...

This could be permissions on the services file.

What happens the second time this value changes? The third time? Perhaps your design requires a child table to record the change history.

I think it's important to discover whether this was, in fact, the case so that you can educate your users about the dangers of manually enhancing data.

What's changed between when it worked and now? ("Nothing" is not the correct answer.) What is the date/time modified stamp on the schema file? Can you post the entire record schema definition? Does the schema file have a line terminator on the last line?

Not really enough information. How is the "extraction" defined? Where are you measuring the row count? Does your job include a rejects link?

There's not really a way to execute two commands from one "starter" process on any computer. The invocation commands can not be executed other than sequentially. The only way to get them to start absolutely at the same time would be to use multiple queues in a scheduler. And even then you ...

You have marked the job type as TX. Please verify whether this is correct. From your terminology I doubt that it is.

Premium membership is one of the ways that DSXchange's hosting and bandwidth costs are funded. I do not propose to establish any precedent that undermines the ongoing operation of DSXchange. The alternative is for you to obtain a premium membership. It's not expensive, at less than 30c (Rs 12) per ...

As a general rule the compiler is co-located with the server. One exception is that, when compiling sequences, some XML processing takes place on the client. The generated OSH that is the result of "compiling" is not the whole story. It lives on the server in the RT_SCnnn directory in the ...