How to check for a null value from oracle

[adnice]

Hi,

I am reading data from oracle table where a column of type integer having null values .

In tmap I am trying below 

row1.batch_id==null?1:0  and setting a value 1 or 0 accordingly. But this is giving me an error .

Can someone please help here about how to compare a integer column for null check

Thanks,

a

[Anonymous]

something like

Relational.ISNULL(row1.FL_LOG_ATD_DATE)? row1.ATD_UTC:row1.FL_LOG_ATD_DATE

where

Relational.ISNULL(<column_to_check>)?<value if null>:<value_if_not_null>

[fdenis]

did you allow null value into your row1.Batch_id data type?
in code, did row1.Batch_id defined as Integer (with null) or as int (without null)?

[Anonymous]

In my exemple, the oracle database accept null value for this date.

So, I am testing it with the tmap ...

see attached.

CaptureNULL.PNG

[fdenis]

click on oracle component on … button or on the oranges link and check allow null checkbox on your data. we cannot see it into your pic.