DSXchange

Posted: **Wed Aug 10, 2005 5:47 am**

Hi
Ascential Documentation says Modify Stage is very efficient stage.
I tried using it one of my jobs.
My requirement is to chek in a nullable column for nulls and convert them into a default value.
So I tried the following syntax.

Code: Select all

AGE_OUT=NullToValue(AGE_IN,-1)

But it gives an error saying unidentified conversion/ invalid conversion.

I also tried the function.

Code: Select all

AGE_OUT=IsNull(AGE_IN)

here AGE_OUT is the output column and AGE _IN is the input column.

Can somebody give the syntax for using these function in Modify Stage.

I tried using the syntax listed in the documentation. It did not work.

Posted: **Wed Aug 10, 2005 6:42 am**

Hi,

The syntax to use in Modify Stage is :

Code: Select all

AGE_OUT = handle_null(AGE_IN, -1)

regards

Posted: **Wed Aug 10, 2005 8:32 am**

Hi dsxdev,

Try the below syntax

Code: Select all

AGE_OUT:string = NullToValue(AGE_IN,"-1")

Posted: **Thu Aug 11, 2005 9:00 am**

Hi pnchowdary,

I am sure this piece does not work.
I tried it out but in vain.

Code: Select all

AGE_OUT:string = NullToValue(AGE_IN,"-1")

By the way in which pdf talks about these function.
I would appreciate if any one can provide any pointers to these pdf's

DSXchange

Syntax of IsNull in Modify Stage

Syntax of IsNull in Modify Stage

Syntax of IsNull is Handle_Null in Modify Stage