cancel
Showing results for 
Search instead for 
Did you mean: 

Receiver JDBC adapter to SELECT is null records?

Former Member
0 Kudos

Hi,

I have an interface with an Oracle database and I need to read only the records that have a null value in a field.

I have created the mappings and all work fine except the selection for this records, in other words I need simulate in the where clausule an 'is null'.

Select field1 field2 from table tab1 where field1 = 'A' and field2 = 'B' and boldfield3 is nullbold

I have try with attributes isNULL and hasQuot but doesn't works

Could somebody help me?

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hai !

I agree with the Query given by BaskerGopal.

Try that.

Regard's

Preethi.

Former Member
0 Kudos

HI

you must use "ISNull" in your condition statement.

Naoki

former_member208856
Active Contributor
0 Kudos

try ' ' in your query inplace of Null.

Select field1 field2 from table tab1 where field1 = 'A' and field2 = 'B' and field3 = ' '

Former Member
0 Kudos

select <field1>,<field2> from <table> where <fieldn> is null and <fieldm> = 'aaa'

The above query worked for us in Oracle, so guess this should solve your problem

Regards

baskar_gopalakrishnan2
Active Contributor
0 Kudos

Try this...

Select field1,field2 from tab1 where field1='A'  and field2='B'  and field3 IS NULL;