DSXchange

Posted: **Fri May 06, 2011 8:28 am**

Hi,

I am newbee in datastage. I am trying to explore Modify stage. I am going through the Parallel Job Developers Guide. There a converstion function "NullToValue" is mentioned for null handling. But when I am trying to use it in my job it is throwing error.

Error Message:

"main_program: Error parsing modify adapter: Error in binding: Unknown conversion: NullToValue"

Can anybody throw some light on this?

Posted: **Fri May 06, 2011 8:50 am**

"NullToValue" is used in transformers and not in modify stage..

In modify stage it should be something like..

PHONE = handle_null (PHONE,-128)

See Parallel Job Developers Guide under Modify stage.

Posted: **Fri May 06, 2011 9:36 am**

Ok Thanks..but actually in parallel job developers guide it is given NullToValue.

Posted: **Fri May 06, 2011 10:10 am**

Unfortunately, the Guide is known to have misinformation in it regarding the Modify stage.

Posted: **Fri May 06, 2011 12:13 pm**

something more comprehensive

http://it.toolbox.com/blogs/infosphere/ ... ster-20368

DSXchange

Modify Stage Question

Modify Stage Question