DSXchange

Use stage variable to remember the earlier row and to generate the running total. Make it the same data type as the output column, which must be compatible with the data type of Amount. Initialize the stage variable to 0.

ODBCINI is not a mandatory environment variable. If present it is on the server. Access Windows environment variables through Control Panel > System

Check that the Netezza appliance is running, not quiesced, and that there is a network path available.

It won't be managed automatically by DataStage. Taking the more general view there are many different ways for identifying deltas, and not everyone uses the same column name(s) for the column(s) that identify the deltas, so there's no automation possible.

Welcome aboard.

Using Web Console for Information Server login as Suite Administrator and open the Domain Management menu on the Administration tab. That's where credentials are set. The error suggests that they have not been set.

Yes, but you will likely lose QualityStage components that your developers have developed. Is this desirable?

First confirm that you have the correct job number. Can you see the job in Director? If so, you can clear the log and status files from there. You should never clear the config file. This contains the dependencies between the objects in the job. And you haven't mentioned other files, like RT_BP488, ...

You can obtain even more understanding by inspecting the Job Control code that is generated when the sequence is compiled.

You get a rough idea when logging in. If the services machine is different from the machine on which your project lies, then you're using at least a three-tier topology (since you're on UNIX and the client tier must be on Windows). I think it unlikely that yours is a four-tier topology, since best p...

Please post the entirety of this message, including the information about the stage that's generating it.

What is the data type of the source and of the target?

Date data type is stored in a binary format, and does not have a format.

If you're reading from a string and writing to a string, convert from string to date and then back to string, each time with an appropriate format specification.

Why should U search on it, given that it's dudam's question?

No. The Quality folder contains QualityStage components that you're developing and provisioning to the server.

What do you mean by 'not executing'? Add an entry to the Logging Text field of the Routine activity, this will cause an event to be logged when the Routine Activity is invoked. If it is not being invoked then you have to determine whether any upstream trigger is preventing it from being invoked. If ...

The word "this" in Craig's response is blue, indicating that it is a hyperlink to something else.