Modify Stage Question

Bicchu · Post by **Bicchu** » 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?

synsog · Post by **synsog** » 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.

Bicchu · Post by **Bicchu** » Fri May 06, 2011 9:36 am

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

chulett · Post by **chulett** » Fri May 06, 2011 10:10 am

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

Nagaraj · Post by **Nagaraj** » Fri May 06, 2011 12:13 pm

something more comprehensive

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