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