Skip to Content

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

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ú

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