DSXchange

synsog wrote:Please help me on this issue and let me know what exactly causing the issue.

Have you tried searching online for the error code? Or asking your Teradata DBA? Those should be the first things you do.

Another suggestion? Upgrade. Your solutions are being limited by the age of your version. Transformer looping (introduced in 8.5 from what I recall) would give you a better solution.

As noted, no since that's not what you asked for... and a quick check of the documentation would have answered your question. If you ever need that functionality, the Ceil() function would be appropriate.

iq_etl wrote:Would we lose any efficiency/processing by using a BASIC Transformer stage in our parallel jobs? Would it make more sense to write a parallel routine (which needs to be in C, correct?)

Yes. Yes. Yes++.

I was under the impression that having more than one marked repetition element would cause an abort... no?

Of course. More pseudo-code than actual "code code" in this case, me thinks.

That would be my job much of the time... done.

Just saying that the derivation as posted makes no sense. IF deptno = deptno Then deptno +1 Else 1 The bold part above needs to be some other variable. And (pet peeve alert) since the fake data you posted was only "similar" to whatever you are really doing, we've got no way to know what th...

MOD() the field by 100 or whatever... if the answer is zero there's no remainder and thus evenly divisible.

Prince_Hyd wrote:IF deptno = deptno Then deptno+1 Else 1

You might want to double-check the code you posted...

"Some what"? Give us a shot at clarifying whatever remains unanswered or unclear...

We still haven't come anywhere close to solving the issue of why after it fails it reruns successfully with the same data. Adding in explicit conversions and validity checks could help narrow that down, be sure to come back once you've done that and let us know where things stand.

What database? Basic answer would be to "raise an error" so the calling process knows something went wrong.

iq_etl wrote:What is meant by 'cast to decimal type in query'.

CAST function. As to your last question - no, it would be whatever data type you are casting to.