DSXchange

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

What's the error message?

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

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

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

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.