I have to specify null value to a column as the default value
@NULL system variable could be used for this is DS server version but this variable is not coming in paralle.
How could this be achieved?
system variable
Moderators: chulett, rschirm, roy
-
JoshGeorge
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
SetNull()
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
SetNull() in Transformer stage, makeNull() in Modify stage, or something like SELECT CASE WHEN 1 = 0 THEN 0 ELSE NULL END FROM DUAL in user-defined SQL in a database 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.