DSXchange

When I try to set a stage variable to a NULL value using SetNull(), and I use this stage variable in an output derivation for a nullable field, the output becomes 0 (integer field) or an empty string (string field).

For example if I have
- an integer stagevariable svar defined as ''
- two nullable integer outputfields:
- f1: defined as - f2: defined as (same expression as for svar).

I would expect the result for both integer fields to be NULL.
However the output for f1=0, for f2 it is NULL.

Can a stage variable not be NULL, or what is my problem?

Try to set the stage variable properties.

check the properties of stage variables which should solve the issue.

Stage variables are non-nullable.

If stage variable property is non-nullable then we should not assign any null value to the stage variable. If we do we get a default value of 0.

Raghavendra wrote:check the properties of stage variables which should solve the issue.
..
If stage variable property is non-nullable then we should not assign any null value to the stage variable. If we do we get a default value of 0.

You make it sound like there is a property you can set to make a stage variable nullable. I can't find anything like that though.

So I assume battaliou is right and stage variables are always non-nullable indeed.

Yes stage variables are always not nullable and so we cannot use setnull function in the stage variable. Sorry for creating the confusion.