Skip to Content

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

JDBC receiver with select is null

Hi,

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├║

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