Null Value in Stage variable and related fatal error

[RAJARP]

Hi all.


Intially i had one expression for a stage variable

Code: Select all

 if  TrimIndicator ='A' and ValidZip='ZIPVALID' and ValidMail='MAILVALID' and ValidSmail='SMAILVALID'
     
     then
     'VALID'
     else
'REJECT'

I got one fatal error 'Null value on the accessor interfacing to field "INDICATOR".'

Note :where TrimIndicator is a stage variable with expression 'Trim(NullToEmpty(transformer_link.INDICATOR))'

and it has null values too.




so i modified the expression as follows

Code: Select all

 if TrimIndicator='' then
 'REJECT'
 
 else
 
 (if ValidZip='ZIPVALID' and ValidMail='MAILVALID' and ValidSmail='SMAILVALID' 
 
 then 
 'VALID'
 else
'REJECT')

and i did not got any error.

so i want to know what went wrong in the first case. Your help would be highly appreciated

Regards,
Raja R P

[asorrell]

The only way to get that error message is to do a test or a function (other than the "Null" type functions) on a field that contains a null value.

For instance in your original code where you say " if TrimIndicator ='A'", if you had not put the NulltoEmpty conversion in place prior to that test - you'd have the problem.

[RAJARP]

hi asorell,
Thanks for your time.In my code, before using " if TrimIndicator ='A' " i had put the NulltoEmpty conversion .Even then i got that fatal error.

Thanks,
Raja R P

[Sreedhar]

Before I can answer you question I would like to know the source of your data.

[mkkgupta]

modify your Stg Var. by using if then else.

if Isnull(Input) then some value else trim(input)
then reject based on value given in Stg var.

[RAJARP]

sreedhar,
my data source is an oracle table.

Thanks,
Raja R P