DSXchange

Hi,
In one of my jobs, I'm using the Transformer for the NULL handling. The way I'm writing is:
If trim(***)="" then "" else ***- The input metadata is Nullable but the output not.
Now, I'm trying to do the same thing using modify stage with HANDLE_NULL(). If I make a statement like:
A=HANDLE_NULL(A,'B') or A=HANDLE_NULL(A) it works. But If I put something like:
A=HANDLE_NULL(A,'')- it doesn't work. How can I write something similar to above mentioned If Then else stat. so I'll be ble to replce NULL with '' or "".

There is a Chapter on the Modify stage in Parallel Job Developer's Guide. One of the things it describes is how to change the nullability of a field. It also describes the available null-handling functions for that stage type.