DSXchange

ODBC uses ODBC protocols (ODBC being a standard invented by Microsoft originally). Oracle stages use Oracle Client Interface (OCI) protocols.

The difference between "using" them is simply which one you choose to emplace in your job design.

All calculations in Aggregator stage work in dfloat. That is the source of the alert message. Have you set the Decimal Output property for this particular field, or globally in the Aggregator stage? This alert may be ignored, and therefore is safe to demote to informational using a message handler.

WHERE in the Transformer stage? A CALL statement - indeed any statement - is not possible where an expression is required, including stage variable initialization, stage variable evaluation, constraints on output links and output column derivations. But you could make such a call within an after-sta...

Re-index the repository in your Dev environment.

Can you open DataStage Administrator, and look at the license information there? The "2 2" refers to the "UniVerse" licensing.

Sounds like one for your vendor to resolve.

The statistics are always cleared by compilation and reset. Check that your job monitor is running. That the stages show as ready suggests that the repository status table has failed to be updated.

Moderator: please move to parallel forum

The parallel Aggregator is a different beast from the server Aggregator.

Yes, but probably involve you creating your own after-stage subroutine.

There is no "one size fits all" answer other than:
1. analyze what the server job does
2. implement that logic in a parallel job

The 2 2 combination does indicate an expired license.

UPDATE is always slower anyway. Each insert merely has to write a row into (at the end of some physical structure in) the table. An update has to find that row, read that row, change the indicated column values, and then write the row back. If it fits in its original position it can be written back ...

Search is your friend. Others have attempted this in the past, and reported their findings.

A hash file is a tool for shaping a block of hash. A hashed file, on the other hand, is one way of implementing a database table, a way that is used within DataStage. Search DSXchange for a precise answer, which I have documented in the past. But search for "hashed file" rather than "hash file". May...

Find out what it is that you're adding or multiplying that would cause an arithmetic overflow.