Skip to Content
avatar image
Former Member

Sending a message when an Insert statement has been successful

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 14, 2006 at 08:14 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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