Stage Variable problem

somu_june · Post by **somu_june** » Fri Jul 11, 2008 2:45 pm

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.

chulett · Post by **chulett** » Fri Jul 11, 2008 3:14 pm

The short answer is 'no'. As noted, they are non-nullable.

ray.wurlod · Post by **ray.wurlod** » Fri Jul 11, 2008 5:41 pm

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.