topic Re: How to check for a null value from oracle in Talend Studio

How to check for a null value from oracle

adnice — Thu, 06 Jun 2019 10:34:33 GMT

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,

Anonymous — Thu, 06 Jun 2019 12:55:42 GMT

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 — Thu, 06 Jun 2019 13:32:31 GMT

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 — Thu, 06 Jun 2019 14:18:08 GMT

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

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

see attached.

fdenis — Thu, 06 Jun 2019 14:31:15 GMT

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.