DSXchange

Hi ,
in my job input is a sequential file(output of some other job).One of the field is decimal(4,16).For null value this field takes "0000000000000"(16 zero).I need to handel this zero and make it as 0.Please advice me how to do this.

Hi ,

If your requirement is to handle just a fixed width string "000000000000000000000000000"
then just add a simple if INPUT_VALUE="000000000000000000000000000" then 0 else INPUT_VALUE

That zero already is a zero - simply moving it to a number field should "handle" it just fine. What issue are you having?

All zeroes is not, by default, legal for Decimal data type.

There is something you can set (environment variable?) that allows DataStage to accept all zeroes for a decimal number.

That sounds vaguely familiar but no clue where that setting would be. Would not "math" also fix that, for example multiplying by 1?

It's the fix_zero argument to the conversion functions.

Parallel Job Developer's Guide p628 wrote:By default decimal numbers comprising all zeroes are treated as invalid. If the string fix_zero is specified as a second argument, then all zero decimal values are regarded as valid.

Ah... that's why it sounded vaguely familiar - you're talking PX and this is a Server issue. Perhaps even a Server non-issue.

Thanks for help.I have to check my job once i will be in office on monday and let you know wheather my problem is resolved or not.