Skip to Content

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

SQL Statement out of BPM

Hi all,

maybe it will be a quick hit for you, but I searched hours to find the solution.

My scenario is the following:

I receive a resultset from an JDBC Adapter. The requested Table has only four rows

with to coulums. The table refelects the status of four scanning devices and has

different statuses like 1,2,3, etc. Therefore I get back a message like described

in the help (http://help.sap.com/saphelp_nw04/helpdata/de/7e/5df96381ec72468a00815dd80f8b63/frameset.htm)

<resultset>

<row>

<ScannerNb>1</ ScannerNb>

<Status>2</ Status>

</row>

<row>

<ScannerNb>2</ ScannerNb>

<Status>0</ Status>

</row>

<row>

<ScannerNb>3</ ScannerNb>

<Status>2</ Status>

</row>

<row>

<ScannerNb>4</ ScannerNb>

<Status>0</ Status>

</row>

</resultset>

This message is forwarded to a BPM which first do a switch. If all Status are 0

then send and update Statement to the database and set all statuses to 4, otherwise

cancel.

To do that I would like to send just an update statement like described in the help

(http://help.sap.com/saphelp_nw04/helpdata/de/43/6211331c895f6ce10000000a1553f6/frameset.htm)

<root>

<stmt>

<ScanningStatus action="SQL_DML">

<access> UPDATE ScanningStatus SET Status=4

</access>

</Customers>

</stmt>

</root>

The Weblog "Save time with generalized JDBC datatypes"

(/people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes) describes how to do a mapping

between these both messages but the source message will not transfer any values to the target

message. Can I send a fixed message, here my SQL Statement, directly to the database out of the

BPM without doing an unneeded mapping before?

Regards Oliver

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