DSXchange

Could this be the 64-bit library being found instead of the 32-bit library? Check the shared library search list environment variable on each of the systems. This is one of LD_LIBRARY_PATH, SHLIB_PATH or LIBPATH, depending on what kind of UNIX you're using.

1. Demonstrate that you are using the sequence correctly.
2. Prove that the Oracle sequence is not locked as you are trying to use it (you may need to involve your DBA in this).
3. Monitor the SQL that is arriving in Oracle from DataStage (ditto).

Definitely no. Any attempt will generate an error message of the form "can not be installed on this platform". Indeed even XP Pro is not officially supported.

Why do you need a server routine? You can't call that from a parallel job. What do you believe to be problematic about the solution I already gave you? The lookup will be performed against a one-row virtual Data Set. If you want to go your way, do it in a job sequence. Don't write code. Code has an ...

Fact: Remove duplicates can be performed in any stage that has an input link. The answer to your question may well be dependent on the data type of the keys and the size of the records. I would suggest experimentation to determine whether there is any difference at all. There is a startup (calling)...

One job for each and a job sequence to make the decision.

Forget Sol2. Anything with code carries a maintenance overhead. Use a Lookup stage to get the comparison value. Perform the comparison downstream of that. Extract2 | | V Extract1 ----> Lookup ----> Filter -----> Extract2 is of the form SELECT 'X', value FROM table (the constant 'X' is important). Ex...

If you can't find an int32_from_string() function - I did mention that it was from memory - use decimal_from_string() and specify a scale of 0.

We await clarification from priyadarshikunal.

OK, DataStage can do all that. Assuming you're using a parallel job, the Sequential File stage will reject any record that does not match the number/width of fields and can capture these on a reject link. Format you would have to do field-by-field (obviously) in a Transformer stage. In a server job ...

This seems to be coming up in a number of the products, so searching in the DataStage forums might prove fruitful, and also suggests that the problem is client-side rather than server-side. Obviously you also need to involve your support provider, in case there's some patch that's available.

I don't believe that U's technical expertise is up to providing the explanation you seek so I will attempt your edification. hashvalue = f(keyvalue) hashvalue is the uint32 result f() is the partitioning algorithm partition_number_for_row = Mod(hashvalue, partition_count) There is a ...

Modulus is more efficient than Hash, because the step of calculating the "hashvalue" is not required - the integer itself is divided by the number of partitions and the remainder is used as the partition for that row. This will guarantee key adjacency. Note, however, that Modulus is only relevant fo...

Do you re-boot Windows after uninstalling? Do you check that all keys have been removed from the Registry by the uninstall process?

Whatever gave you the idea that DataStage was a reporting tool? It is not.