NULL Handling using Modify stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Bilwakunj
Participant
Posts: 59
Joined: Fri Sep 10, 2004 7:00 am

NULL Handling using Modify stage

Post by Bilwakunj »

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 "".
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
Post Reply