Skip to Content
0
Jun 21, 2021 at 03:43 PM

SAP PO JDBC SQL_DML statement built within mapping fails because quotes are removed

40 Views Last edit Jun 21, 2021 at 03:44 PM 2 rev

Hi experts,

I've built my query statement as per this help page.

The resulting xml is the following.

<?xml version="1.0" encoding="UTF-8"?>
<ns1:root xmlns:ns1="http://namespace">
	<stmt>
		<table action="SQL_DML">
			<access>select [col1] as name1, 'A' as type, [.. sql statement ..] where date = '$Date$'</access>
			<key>
				<Date>2018-01-21</Date>
			</key>
		</table>
	</stmt>
</ns1:root>

The placeholders replacement works fine (I used '$<keyField>$' in the mapping as suggested in the help page).

But the jdbc receiver adapter removes my quotes. I need to keep them otherwise the query is not working. How can I do that?

Regards.

Cristian