Set Null

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
Nagin
Charter Member
Charter Member
Posts: 89
Joined: Thu Jan 26, 2006 12:37 pm

Set Null

Post by Nagin »

In version 8x, If I use SetNull() function in the transformer to set the value of a column to null, it is setting the column value to "NULL" but not the actual null like the @NULL function in Basic Transformer.

Does any one know why? Or how to get the actual NULL inserted?

Thanks.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

No it isn't. Something you are doing downstream of the transformer stage is converting the true null to the representation "NULL" - probably a null field value, my guess is in a Sequential File stage's input link metadata.

IS there a SetNull() function in a server job Transformer stage?
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