What is divide by zero rule.

[FranklinE]

I am calculating a column like this

Column A = (Column B+Column C)/Column D

Now if suppose a zero value comes at Column D then the Datastage will through an exception ..or an error so how can I handle this..

????

Standard approach: Insert If condition before doing calculation that defaults Column A = 0 (or any other branch action you wish) if Column D = 0. This will prevent divide by zero.

[chulett]

In other words, check first and only perform the division when the divisor is not zero.

[FranklinE]

After further thought, it occured to me that this issue should start in the requirements. Any amount that is intended to be used as a denominator should have error handling for zero before it gets to the calculation. In COBOL, this is a standard item for an entire paragraph that does nothing but validate fields. Dates are also handled there, along with any more specific constraints on the data (not more than x days old, etc.)

In DS, I'd probably look first at either a filter stage or have constraint/branches on the transformer. I usually see a requirement for a reject report that needs to display the entire rejected record.

Do you trust your data source? Sometimes it's not (just) paranoia to answer "no".

[tanaya.deshpande@tieto.co]

Thanks you guys My problem is solved :D