Skip to Content
avatar image
Former Member

Sending a message when an Insert statement has been successful


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


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 14, 2006 at 08:14 AM


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

    let me know if you need further info



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member


      read this from SAP HELP.


      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.