Hi,
Iam using a stage variable "SV" and it has data type varchar 255, in derivation field for SV I have given expression as
IF ln1.DIV = '20' then (Trim(ln1.con),4) else SetNull()
When Iam compiling a job it is giving an error saying
Setting null to this non-nullable field: StageVar0_SV.
I need help in this stage variable issue. My question is can I use SetNull function in stage variable, if so how to do that
Thanks,
Somaraju.
Stage Variable problem
Moderators: chulett, rschirm, roy
Stage Variable problem
somaraju
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Use an "In-band null" - a value that is valid for the data type, that represents null and that will not otherwise appear in the data. Convert this to an actual null in a downstream Modify stage using handle_null() or a 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.