DSXchange

What is divide by zero rule?
Why is it implimented ?
How is it implimented?

Not really any kind of explicit DataStage question, is it? So...

http://en.wikipedia.org/wiki/Division_by_zero

well yes it is a Datastage question ...
In the past I had implimented this ..but now I have forgotten

I guess in a transformer you're looking at something like:
if NullToZero(Aggregated.ITEMTOT) + 0 then 0 else Aggregated.ITEMTOT/Aggregated.ITEMTOT

tanaya.deshpande@tieto.co wrote:well yes it is a Datastage question ...

Not the way you phrased it. Add in a specific example or a DataStage error or problem you are seeing and then I'd agree. Otherwise it's just an excercise in Googling.

In the old days of assmebler dumps, we mainframers would flinch every time we saw a SOC7 error, which usually happens when our code tries to divide by zero (It's not my fault! It's the data!)

I coworker just this morning told the story of when he asked "What's a SOC4?" His mentor didn't miss a beat, and answered "It's what you put on your foot in the morning."

The simplest answer to the question "What is divide by zero rule"? Don't

And I still use my yellow card to this day...

In addition to the divide-by-zero, S0C7 also came around because of invalid packed decimal data . Ah, the fun of tracing subroutine calls via R14 through a DOS dump!

We're all dating ourselves here. Aren't too many of us around who can still "read" hex, let alone do calculations on it or immediately recognize a zone decimal from a packed decimal from an integer... (and so on)... Sigh. A lost art.

Ernie

eostic wrote:We're all dating ourselves here. Aren't too many of us around who can still "read" hex, let alone do calculations on it or immediately recognize a zone decimal from a packed decimal from an integer... (and so on)... Sigh. A lost art.

Ernie

Take heart, Ernie. My IT education sources (hereafter unnamed) tell me that the larger companies with big legacy code bases are screaming for mainframe curricula to be brought back. I'm hoping for the possibility of a part-time job at a community college or small liberal arts college to keep me busy after retirement, but if not I doubt I'll lack contracts.

First time I've encountered COBOL being described as a "liberal art".

Well, it is a very wordy language, but not quite poetic

Ha, Ray! My COBOL instructor way back when was the IT directory for a small book publisher. There's a "liberal" and an "art" in there for the asking.

Meanwhile, back on topic, the correct answer (mathematically) is that "division by zero is not defined". In a DataStage parallel Transformer stage it should cause an exception.

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..

????