JDBC receiver with select is null
I need to do a mapping between SAP and an Oracl database, but there is a issue that I can not solve.
I need that the mapping do a call like:
SELECT field1 field2 FROM table1 WHERE field1 = 'value1' and field2 = 'value2' and field3 is null.
I can do all steps except include the "is null" in the where clausule, I have tried using the key attributes but seems that it doesn't work like I need.
Could someboy help me? How can get the SQL sentence that the JDBC adapter generate.
Best regards, Raú