NullToValue function

KeithM · Post by **KeithM** » Thu May 13, 2004 9:08 am

In the past I have used the NullToEmpty function with success. Now I am trying to use the NullToValue fuction and I cannot get it to work. I can get around the problem by using an "If Isnull" statement but I am wondering what I am doing wrong. Can someone give me an example of how to use this function or does it not work?

Thanks

kcbland · Post by **kcbland** » Thu May 13, 2004 9:28 am

What's the error message?

KeithM · Post by **KeithM** » Thu May 13, 2004 9:48 am

This is how I am calling the function:
NullToValue(lnkLkpCountry.Country_Key, 1)

The error message is:
Array 'NullToValue' never dimensioned.

kcbland · Post by **kcbland** » Thu May 13, 2004 10:15 am

Where/how are you using this function? Either it's not compiled or you are using inside another function without a DEFFUN statement.

KeithM · Post by **KeithM** » Thu May 13, 2004 11:53 am

Thanks, this helped me find out what my problem was. I was trying to use the function in a transformer stage. There was no transform function defined for NullToValue but there was one for NullToEmpty. I created one for NullToValue and now it works.