Modify stage - null handling

miwinter · Post by **miwinter** » Fri Nov 09, 2007 5:17 am

Hi guys,

The Parallel Job Developer's Guide (page 28-4) shows an example of null handling for conversion of null to a char. I was looking to use this as I'm outputting to a seq file. However, if you use the example they recommend, you soon discover that there is no such conversion function as 'NullToValue' for the Modify. I know this exists in a Transform, but it doesn't appear to be valid for a Modify. When running the job, it returns:

Error parsing modify adapter: Error in binding: Unknown conversion: null_to_value
Expected destination field selector, got: ")"; input:

Looks like a documentation oversight to me...

Is there an alternative to this for the Modify, to achieve the same end? I've checked the available conversions in the same guide, from page 28-7 onward, but only 'null' and 'notnull' functions seem to exist.

Cheers

balajisr · Post by **balajisr** » Fri Nov 09, 2007 6:05 am

You need to use handle_null() instead of NullToValue().

miwinter · Post by **miwinter** » Fri Nov 09, 2007 6:08 am

Thanks - dodgy documentation indeed then!

jhmckeever · Post by **jhmckeever** » Sun Nov 11, 2007 5:48 pm

The Modify operator is more fully (i.e. correctly!) documented in the Orchestrate Operators Reference.