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)
I also tried the function.
Code: Select all
AGE_OUT=IsNull(AGE_IN)
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.