Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Receiver JDBC adapter to SELECT is null records?


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?

Not what you were looking for? View more on this topic or Ask a question