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 "".
NULL Handling using Modify stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.