DSXchange

Posted: **Mon May 28, 2007 10:34 pm**

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?

Posted: **Mon May 28, 2007 10:36 pm**

SetNull()

Posted: **Mon May 28, 2007 11:21 pm**

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.