DSXchange

It seems both input and output links have column "MISCORR". If this column is not a join key, the stage only carry the left link's "MISCORR" field and will drop the right link's. Suggest you to remove input link's unnecessary columns to avoid this kind of warning messages. You ma...

You may also check the "null field value" property set in "Sequential file stage". In your case, the transformer / the sequential file would drop records if : 1. transformer : put a "NULL" to a non-nullable field OR 2. sequential file : you have not set "null field...

If you want to apply to whole project, you may set environment variable APT_STRING_PADCHAR. Thats quite convenient in Parallel engine.

I've tested but seems these three ...INTERM... parameters do not affected the results.

Thanks for your suggestions again.

Hi, kumar_s Lets for sharing. I have change setting of APT_DECIMAL_INTERM_SCALE and APT_DECIMAL_INTERM_PRECISION but never change on APT_DECIMAL_INTERM_ROUND_MODE. It is now APT_DECIMAL_INTERM_SCALE = 38 and APT_DECIMAL_INTERM_PRECISION = 10 Make APT_DECIMAL_INTERM_SCALE and APT_DECIMAL_INTERM_PRECI...

Thank you, ray.

Let me report this issue and kindly share my experience to the others.

Hi, ray As mentioned, it always gives wrong answer in decimal places e.g. 123456789012345.123 - 0.000 ==> 123456789012345.058 123456789012345.123 - 0.001 ==> 123456789012345.121 ... Not only the subtraction encountered this problem but also using parallel function "NullToZero()". I have te...

Hi, all

I have experienced that when I subtract two numbers,
datastage always give wrong results in the decimal places.

e.g. 123456789012345.123 - 0.000 ==> 123456789012345.xxx

I have changed related environment variables in Project but seems no
effect.

Does anyone know how to solve it ?

Hi, just want to give some ideas to you: You may use empty string ('') to represent a null date when writing sequential file ( by setting the "Null field value" property ) but when you want to read empty string ('') into a nullable date field, datastage fatal error : [ ... cannot have a &q...

The "where clause" of Filter Stage does not allow "trim function" in it. Extra stage to handle "trim" is needed. On the other hand, you should pay attention to the where clause you set. In your case, set a = b is different from b = a for a is varchar(2) and b is varchar...