Coalesce Function

mail2krishna79 · Post by **mail2krishna79** » Tue Apr 19, 2011 1:10 pm

I can see Coalesce Function in Oracle 9i, Oracle 10g, Oracle 11g.

Is there any equal function in DataStge 8.1 or 8.5?

jwiles · Post by **jwiles** » Tue Apr 19, 2011 1:56 pm

A very simple forum search on the term coalesce will answer your question.

soumya5891 · Post by **soumya5891** » Wed Apr 20, 2011 12:13 pm

You can use null to value in a transformer stage or a modify stage

ajay.vaidyanathan · Post by **ajay.vaidyanathan** » Wed Apr 20, 2011 1:24 pm

You can use NullToValue() or NullToZero() in Transformer Stage or you can use NVL() at source DB Stage.

Your Choice

Regards,
Ajay

Sreenivasulu · Post by **Sreenivasulu** » Thu Apr 21, 2011 12:46 am

coalesce takes the first notnull out of the input set of values. I think he is asking that sort of straighforward function in datastage ?

Regards
Sreeni

zulfi123786 · Post by **zulfi123786** » Thu Apr 21, 2011 1:53 am

A nested if then else would do.

If you dont want to see the nested if then else then enclose it in a routine to get a function like feel. all of this valid for more than one arguments, for one argument you have NullToValue()