Sending a message when an Insert statement has been successful

[Former Member]

Hi

I would like to find out what the easiest way would be to send a message back to XI when an Insert from a JDBC_Reciever_Adapter was successful/unsuccessful.

Thanks in advance for your help

Clinton

[bhavesh_kantilal]

Hi,

Configure JDBC adapter in a Synchronous Fashion which will send you info on the Insert_Count andf Update _Count.

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

let me know if you need further info

Regards,

Bhavesh

[Former Member]

Hi,

read this from SAP HELP.

action=INSERT

Statements with this action cause table values to be inserted. Therefore, the statement corresponds to an SQL INSERT statement.

The <access> block contains the new column values.

A statement with the action INSERT must have at least one <access>element. It cannot have a <key> element.

The corresponding SQL statement for StatementName2 in the example above is as follows:

“

INSERT INTO dbTableName (col1, col2) VALUES(‘val1’, ‘val2’)

INSERT INTO dbTableName (col1) VALUES(‘val11’)

“

<i>The response document contains the following element as well as the number of inserted table lines, including 0.

<insert_count>count</insert_count></i>

Regards

Vijaya